AD 2005-01-19
Registered aircraft · 140,127
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:2005-01-19')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2005-01-19')
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:2005-01-19') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2005-01-19') 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.
N1005FBeam Douglas J Trustee · Chugiak, AKN1005QRegistration Pending · Fairmont, WVRegistration pendingN1005UHapka Michael · Winchester, INN1005XSigler Lanny · Albuquerque, NMN10069Silvestri Leonardo · Ellicott City, MDN1006ABixler Robert · Midland, MIN1006DObrian Laurence J · Northridge, CAN1006UFike Brian Arthur · Florissant, CON1006VLanier Equipment Leasing LLC · Gainesville, GAN1006WFadem Justin Andrew · Williamsville, NYN10074Linder Matthew L · Kalkaska, MIN10079Wier Michael D · Pompano Beach, FLN1007CVee Two Inc · Merritt Island, FLN1007F007 Aviation LLC · Wilmington, DEN1007LPlane Fun Inc Tr Trustee · Snellville, GAN1007NNewberg Edgar T · Hector, MNN1007RUts Aviation LLC · Gainesville, VAFirst renewal noticeN1007SNmaer Inc · Orlando, FLN1007THollar Larry · Winston Salem, NCN1007UKallam Jerry · Palmer, AKN1007VSmith Loren Dallas · Great Falls, MTN1007XD&R LLC · Emory, TXN1008AAerial Surveys International LLC · Watkins, CON1008CBat Flying LLC · Blue Earth, MNN1008DRussellaire LLC · Darby, MTN1008KAu Jerry · Manhattan Beach, CAN1008LWilson Jeffrey M · Upper Arlington, OHN1008MHottenstein William R · Kingston, PAN1008NK W Racing LLC · Angola, INN1008RNicholas B Hall · Tampa, FLN1008WRay Jonas · Palmer, AKN1008XSmith Dan V · Anchorage, AKN1009AWilliams Wendell · Anchorage, AKN1009CFord Richard B · Hendersonville, NCN1009DWelch Thomas R · Modesto, CAN1009MPrecision Wings LLC · Saint Augustine, FLN1009PFerrier William T · Woodland, CAN1009QWatson James E Jr · Victor, CON1009XEnders Richard A · San Bernardino, CAN100ABLandry Camile J · Baton Rouge, LAN100AESale Reported · Spencer, NESale reported, pending cancellationN100AJN8006j LLC · Shiloh, ILN100ANWatson Family Investments LLC · Houston, TXN100AWDe La Torre Alfonso Jr · Brownsville, TXN100AZNnww Holdings LLC · San Angelo, TXN100BMarshall Xavier T · Carson, CAN100BABemidji Aviation Services Inc · Bemidji, MNN100BEBemis Manufacturing Co · Sheboygan Falls, WIN100BHChopper Aviation LLC · Cahokia Heights, ILN100BJAllen David L · Eastpoint, FL
Back to AD 2005-01-19