AD 94-05-05 R1
Registered aircraft · 26,230
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N86184Dewitt Elvin H · Santa Monica, CAN8618BRegistration Pending · Nacogdoches, TXRegistration pendingN8618SBenson Dusty J · Melstone, MTN8618UMorgan Ted R · Grant, FLN8619BBasham James L · Livingston, TXN8619JErickson Max W · Cumberland, WIFirst renewal noticeN8619USpadaro James · Cross Lanes, WVN861TWTailwinds LLC · Ewing, NJN8620JCampbell John L · Lincoln, NEN8620SSorrell Zachariah G · Palmer, AKN8621BMcmillan Thomas J · Milburn, NEN8621GKlopotek Jeffrey D · Waterman, ILFirst renewal noticeN8621UTomsheck Brothers · Oilmont, MTN86237Stewart Cub · Waynesville, OHN8623SBucks Flight Academy LLC · Cashion, OKN8623UBarry Gehret · Sonoma, CAN8624SToth Frank L · Schenevus, NYN8624USikora Randall P · Boca Raton, FLN86250Henry Joseph R · Elizabeth, WVN8625GDelong Erika Dee · Forest Lake, MNN8625SMendoza Erik · Pleasanton, TXN8625URubison John R · Shelbina, MON8626GMcflight Aviation LLC · Highland, UTN8626JSeitz David J · Mauston, WIN8626UFriedman Arthur M · Santa Paula, CAN8627GMahaini Saad · Lucas, TXN8628BScarcella Joseph A · Redlands, CAN8628GLongmuir Charles H · Newport, MEN8628JJacobi Joseph · Mexico, MON8628SDiaz George D · Tucson, AZN86296Brewer Michael A · Fort Wayne, INN8629UHedberg Paul D · Atwater, MNN86307Mcatee Mark D · Casper, WYN8630GGoehring Melissa S · Grand Rapids, MIN8630JDean M O · Corpus Christi, TXN8630UOcala Aviation Services Inc · Ocala, FLN8631JKing Boyd F · Okmulgee, OKN8631SSteiger Marley C · Glenham, SDN8632GChappell Stephen · Wilmington, NCN8633BPrigmore Phillip M · Alva, OKN8633JHise Mark J · Nolensville, TNN8633SUhler John A · Rimrock, AZN8634GRegistration Pending · Princeton, MARegistration pendingN8634JDestination 55 LLC · Cave Springs, ARN8634SHersom Jeffrey T · Helena, MTN8634UTango Thirty One Aero Clube Inc · Mckinney, TXN8635BShafik Mohammed · Las Vegas, NVN8635GSmith Andrew W · Willow, AKN8635SWood Timothy M · Jefferson, MEN8635UTango Thirty One Aero Clube Inc · Mckinney, TX
Back to AD 94-05-05 R1