AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N5255KReighley Robert G · Xenia, OHN5255MFlesher William Robert Jr · Gainesville, GAN5255NLucas David · Lodi, OHN5255RZin Services LLC · Dover, DEN5255SAkc III Aviation LLC · Port Saint Joe, FLN5255TGood Joseph A · Weymouth, MAN5255UFlight Gear Aviation LLC · Pickerington, OHN5255WHoppes Curt · Saint Jacob, ILN52563Concord Flying Club Inc · Lafayette, CAN52564Electrical Systems Professionals Inc · Trinidad, CON5256DTall Timber Flying Service LLC · Kalispell, MTN5256HHenley Robert J · Jeffersonville, INN5256JKamenz Donald R · Mocksville, NCN5256LIngram Aviation LLC · Johns Island, SCN5256NGospel Ministries International · Collegedale, TNN5256SFargo Jet Center LLC · Fargo, NDN52572Corrosion Savants LLC · Wilmington, DEN52577Hartman Edward L · N Canton, OHN5257ASouthern Aircraft Consultancy Inc Trustee · Casper, WYN5257EWings 4 Paws LLC · Yulee, FLN5257HWellman David H · Eugene, ORN5257NAmanda Air Inc · Talladega, ALN5257PAero Nautics Inc · Cheyenne, WYN5257RTheodossiou Chris · Mandeville, LAN5257SSchumaker Grant E · Wichita, KSN52587Mcconal Danny · Seminole, TXN5258ABeta Aviation L L C · Lewes, DEN5258NOffcourt Ltd · Del Mar, CAN5258PMosley Hardy · Elko, NVN5258RZwiesler Thomas F · Ellington, CTN5258YChristiansen Aviation LLC · Wilmington, DEN5258ZSt Pete Aviation Services LLC · Saint Petersburg, FLN52590Aereo Flyers Inc · Camino, CAN52593Mccarthy Justin P · Western Springs, ILN52595Cotton Christopher S · Dallas, TXN5259ECole Charles · Las Vegas, NVN5259GSnowdog LLC · Litchfield Park, AZN5259HTrifunovic Stefan · Grosse Pointe Park, MIN5259LPennsylvania Flying Assoc Inc · Saegertown, PAN5259PPacheco Carlos Antonio · Yuma, AZN5259RCarnathan Robert J · Newark, CAN525AGNoland Ronald E · Weston, ORN525BECya Aviation LLC · Saint Marys, WVN525BHWalker Craig · Pleasant View, TNN525CAWb Aviation LLC · Sugar Grove, ILN525CSPrivitt Bret J · Forest Hill, TXN525DVSky West Aviation Inc Trustee · Albuquerque, NMN525FLSiebert Derrick R · Wausau, WIN525FSWrb Aircraft Leasing LLC · Wilmington, DEN525FWWall Freddy V · Raleigh, NC
Back to AD 2007-04-19 R1