AD 56-06-01
Registered aircraft · 15,143
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:56-06-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:56-06-01')
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:56-06-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:56-06-01') 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.
N1052MFendt Alan D Trustee · Dexter, MIN10554T34sum LLC · Lake In The Hills, ILN1055MRyan Michael W · Long Beach, CAN105BMatthews George W · Hillsboro, OHN105ERSokoloski James J · Lampasas, TXN105MTRegistered aircraftN105SPDepartment Of Emergency Svcs & Public Protection · Hartford, CTN105VBHughes Francis A · Ltl Egg Hbr Twp, NJN1069Byrne Sofia V · Merrimack, NHN1069LWilson Michael A · Everett, WAN106BAnderson Martino G · Lakeland, FLN106NChenevert Eric M · Clarence, NYN106PSScarrow James D · Jerome, IDN106RGCadena Edward R Jr · Houston, TXN106UMiha LLC · Dover, DEN10714Tennessee Museum Of Aviation · Sevierville, TNN10715Noyes Stephen S · Newburyport, MAN1073MScr Aviation LLC · Austin, TXN1077B85 Alpha Inc · Wilmington, DEN107SPDepartment Of Emergency Svc & Public Protection · Hartford, CTN107WFWilcox Farms Inc · Roy, WAN107YYBeezhold Terence J · Lake Stevens, WAN1080MFlying Particles Inc · Livermore, CAN1082PGarrett James D Jr Trustee · Coolidge, AZN1084WLafayette Foundation Inc · Fort Lupton, CON1085MDuncan Terry C Trustee · Cupertino, CAN1086LLade Burton G · Bemidji, MNN1086MSargent John E · Vancouver, WAN1089MPetersen Clayton · Albert Lea, MNN108BCaturia Jeffrey T · Layton, UTN108BTFlying J Aviation LLC · Lynden, WAN108EENorthwood Services Inc · Skwentna, AKN108GWPope James D · Clarkston, WAN108KDPayne Steven H · Nine Mile Falls, WAN108RMFernandez Taylor R · Wasilla, AKN108SPDale County Sheriffs Office · Ozark, ALN108TTTurnbull Archie · Ypsilanti, MIN1090MBergstrom Aircraft Inc · Pasco, WAN10948Morris Jacky D · Watonga, OKN109AKHarris Eric W Jr · Moncks Corner, SCN109DSBell Bradley L · Bothell, WAN109FRoos Patrick R · Purcellville, VAN109WYPerala Daniel R · Cheyenne, WYN109YBraun Joshua S · Port Hope, MIN10EVCafiero Vincent · Haskell, OKN10GCBanks Keith Allen · Salisbury, MDN10GGMartinelli Alexander Joseph · Waco, TXN10JFRempert Erich A · Lake Geneva, WIN10JHHayden Charles J Jr · Richmond, TXN10RRLeonard Christopher S · Moravia, NY
Back to AD 56-06-01