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.
N428EJohnson Zachary H · Anchorage, AKN428EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN428FClark Robert D · Bedford, NHN428FFDhs Operations LLC · Wilmington, DEN428HSSchroebel John Daniel Trustee · Pleasant Hill, CAN428JAJones Terry W · Houston, TXN428JGDr Rotors LLC · Mccall, IDN428JPCal Aircraft LLC · Lewes, DEN428JSHoerr Stacy D · Taylor, MON428KRLilly James D · Columbia, MDN428KWKangas Matthew S · Santa Cruz, CAN428LBMam Aviation LLC · New York, NYN428MRepanshek David J · Hertford, NCN428MTNby Productions · Manassas, VAN428NDUniversity Of North Dakota · Grand Forks, NDN428PABird Acquisition LLC · Phoenix, AZN428PBVander Molen William L · Hudsonville, MIN428RHegy Thomas R · Hartford, WIN428RBHouser Blue D · Edgemoor, SCN428RGGandolfo Air LLC · Watertown, CTN428RVCunningham Gary R II · Satellite Beach, FLN428SGriffing Flying Service Inc · Port Clinton, OHN428SPStar Flight LLC · Johns Creek, GAN428SXMann John Franklin Jr · Marietta, GAN428TLight Korbin T · Midland, TXN428TLJoe Rushing Plumbing Co Inc · Lubbock, TXN428TMBlue Jay Omni Bearing LLC · Fargo, NDN428WAPhillips Jeffry T · Ellensburg, WAN428WJGossett Corey G · Victoria, TXN428WREagle Flying Club Of Embry-Riddle Aeronautical Unv · Daytona Beach, FLN42907Albion Telephone Co · Albion, IDN4290HOwen Toy C · Anchorage, AKN4290ZShearer John W · The Dalles, ORN42911Kenney Stuart C · Atlanta, GAN42912Forouzan Fardad Trustee · Poway, CAN42916Nedwick Lars I · Girdwood, AKN42917Afmr Inc · Dover, DEN42919Tarnutzer Aviation LLC · Wayland, MIN4291HDuclos Jack B · Anchorage, AKN4291JImai Benjamin T · Silverado, CAN4291QRegistered aircraftN4291SHobart Aviation Inc · Akron, OHN42920Sanders Craig A · Stockton, CAN42927Strickland Albert L · Capitola, CAN4292HRoss Peter W Trustee · Lufkin, TXN4292JReds Aircraft LLC · Edinburg, TXN4292QSky Walker Flight School LLC · Adrian, MIN4292YWalters Jason · Palm Springs, CAN4293HHelleberg John R · Centreville, VAN4293JCoastal Virginia Aviation LLC · Chesapeake, VA
Back to AD 2007-04-19 R1