AD 46-36-01
Registered aircraft · 9,759
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:46-36-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:46-36-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:46-36-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:46-36-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.
N1060EMelick Frederick J · Sandusky, OHN10613Presten Eric A · Vineburg, CAN1063EFenton Harry L · Rockton, ILN1063ZDavis Michael W · Richland, WAN1064EBurner Dwight L · Mcgaheysville, VAN10674Urbahn John A · Saratoga Springs, NYN1067EGelvin Stanley M · Central, AKN1069EChamp Wilson E · Lebanon, PAN106PBPioneer Valley Military & Transportation Museum · Westfield, MAN1071EGiannonatti Lance A · Ludlow, SDN1071KLeavitt Craig · Spicewood, TXN1071NWestern Antique Aeroplane & Automobile Museum · Hood River, ORN1072KAlley Shane C · Jackson, MON1078EBuehler Benjamin M · Issaquah, WAN107JABeach Pinkney C · Morganton, NCN1080KLindsey Harold D · Wichita Falls, TXN1082EKnerr Joshua D · Tehachapi, CAN1082KBoese Erich DBA · Oakdale, CAN1084EPetro Jerry R · Williamsburg, VAN1086EPippert James · Dysart, IAN1087EBrindley Matthew · Kalamazoo, MIN1087KMiller Robert L III DBA · Kittrell, NCN1088KTaylor Spencer H · Lake City, FLN108JWLewis Christopher S · Hancock, MIN1091KThompson Isaac R · Stoutsville, OHN1094EHardin John M · Terrell, TXN1094ZBorre Alan D · Palmyra, WIN10952Price Christopher R · Shullsburg, WIN10962Wille Chad C · Corning, IAN10968Dexter Fred H · Live Oak, FLN1097ERegistration Pending · Manley Hot Springs, AKRegistration pendingN1097KWerner Glenn M · Hartwell, GAN109NBiggest Edward J · Cornell, ILN10CYMolek Jon · Warren, OHN10EPManning Christopher S · Dawson, GAN10ERStephenson David A · Pendleton, INN10JLSmith Loren D · Great Falls, MTN11008Hillyard Billy R · Moody, TXN1100KWilkie David J · Nashua, NHN1101BMchugh Ronna R · Salem, ORN1101EChristensen John N · Greenville, MIN1101FMain Marion R · Moravia, IAN1104BTimmons Colton R · Yuma, AZN1104ECoker Garret · Blue Springs, MSN1104KJohnson Christopher · Danville, INN1107Weiss Elliott · Fresno, TXN1107BBacon Joseph M · Fenton, MIN1107ESale Reported · Cass City, MISale reportedN1107KButtonwillow Land & Cattle Co · Buttonwillow, CAN1109KCard William N III · Schwenksville, PA
Back to AD 46-36-01