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.
N558CDSr Global Partners LLC · Laguna Beach, CAN558CPCivil Air Patrol · Maxwell Afb, ALN558EAerodyme Corp · South Burlington, VTN558FLRoyal Greene Holdings LLC · Spout Spring, VAN558JRichley Robert C · Lees Summit, MON558KAtp Aircraft 3 LLC · Wilmington, DEN558MASanders Flight Training Center Inc · Jasper, ALN558MBBarrow Michael B · Reno, NVN558MKSandy River Air LLC · Wilmington, DEN558NDPhoenix East Aviation LLC · Daytona Beach, FLN558PSouth Electrical Inc · Laurinburg, NCN558PCSammons Aero Services LLC · Edgewood, TXN558PPTaylor Thomas J · Sharpsburg, GAN558RBNash Garrett J · Bliss, IDN558RSAyelet Aviation LLC · Mackinac Island, MIN558RT558rt LLC · Rocky Mount, NCN558SHAarow Aircraft Leasing LLC · Mcminnville, ORN558SMTsvang Volodymyr · Redondo Beach, CAN558THScannelli Jeff · Southampton, NYN558TLLally Timothy A · Bell Gardens, CAN558USNorth Central Dakota Partners LLC · West Fargo, NDN558WManticore LLC · Alton, NHN558WHRex Aero LLC · Wilmington, DEN55905Top Coat Takeoff LLC · Cincinnati, OHN55907Gregg Jeffrey B · Sun Valley, CAN5590BChambless Ronald Hugh · Abernathy, TXN5590FLee A Archer Jr Red Tail Youth Flying Progrom Inc · New Windsor, NYN5590JWilliams John S · Cleveland, TXN5590PUdall Thomas H · Mckinney, TXN55913Buckner Business Services Inc · Trenton, MON55915Loncella James G · Johnstown, PAN55919Northstar Group LLC · Dothan, ALN5591ABig Dog I LLC · Wallace, MIN5591BRegistered aircraftN5591DHarrison John C · Northport, MIN5591VCortese Michael C · South Chatham, MAN5591WMontag Mark W · Pine River, WIN55920Gillbreath Monty Everett · Livingston, TXN55925Goodwin Collin H · Hobbs, NMN55928Tao Aviation LLC · Las Vegas, NVN5592BJopson James M · Newman Lake, WAN5592FEagle Air Flying Club Inc · Bowling Green, OHN5592JHyden Josh Vander · Beulah, MIN5592PWelch Roy T · Garfield, WAN5592QGrant Charles A Jr · Denton, TXN5592VBlack Dog Air LLC · Satellite Beach, FLN55930Lafrance Troy R · Paola, KSN55932Red Eagle Aviation LLC · Deridder, LAN55933Knoxville Aviation · Knoxville, IAN55934Roloff Paul E Trustee · Waupaca, WI
Back to AD 2007-04-19 R1