AD 79-10-14 R1
Registered aircraft · 56,582
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N6543DBatte Randall E · Forest, MSN6543FJackson Road Flyers · Wayne, MIN6543TLequire Wayne A · Maryville, TNN6543VChupito Sabrocito LLC · Paso Robles, CAN65447Maxxum Financial Group Inc · Destrehan, LAN6544ESando Jan R · St Louis Park, MNN6544KWaldron Ronald J · Strongsville, OHN6544XAnderson Joseph · Tillamook, ORN6544YSchwarzenberg Johannes · Helena, MTN6545365453 LLC · Blaine, MNN6545AWunrow Steven M · River Falls, WIN6545DCosta Flying Service Inc · Painted Post, NYN6545GBoomer Aviation Inc · Fort Walton Beach, FLN6545HAmerican Patrols Inc · Midland, TXN6545TWallis Jamee G · Auke Bay, AKN6545XTail Chaser LLC · Wilmington, DEN6546AHayden Susan R · North Pole, AKN6546EMenard Keith L · Bellevue, TXN6546NMitchell Matthew J · Penn Yan, NYN6546TDungy Garold E · Gower, MON65471Overland Aviation LLC · Williston, NDN65472Registered aircraftN65477Nistler Joseph C · Helena, MTN6547CJrp Management LLC · Williams, AZN6547GLarson Jerry L Jr · Shelby, MTN6547MLeder John · Marble, NCN6547NHart Anthony · Promise City, IAN6547SMiller Bradley J · Joliet, MTN65489Flight Solutions LLC · Columbia, MON6548ANebesky William E · Anchorage, AKN6548ESewell William G Jr · Bremen, GAN6548GRoeder Paul A · Waukon, IAN6548SDersch Jonathan D · Mullica Hill, NJN6548VMaxwell Frank R · Fairbanks, AKN6548XGardner Maureice E · Garden City, KSN65499Pacific Quality Controls Inc · Wrightwood, CAN6549DBbjs Investments LLC · Waukesha, WIN6549ENewton Donald H · Lewistown, MTN6549GAviaschin LLC · Frisco, TXN6549KBurchinal Sam · Brookston, TXN6549MWhitinger Ryan · Flowery Branch, GAN654ALMoore Howard · Camden, TNN654ASDwyer Sean · Edmonds, WAN654CSCharlies Angel LLC · New Castle, DEN654NDInternational Air Services Inc Trustee · Carson City, NVN654PAPurdue Aviation LLC · West Lafayette, INN654SPJm Air Holdings LLC · Stevensburg, VAN65501Right Rudder Arizona LLC · Litchfield Park, AZN65504Bg Ip LLC · Saratoga, CAN65507Cora & Associates LLC · Norcross, GA
Back to AD 79-10-14 R1