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.
N4856JN4856j LLC · Boulder, CON4856LCraig Peter G · Sequim, WAN4856THub City Aviation LLC · Spartanburg, SCFirst renewal noticeN4856VColombie Michael A · Anchorage, AKN4856YAgland Air Inc · Beaver Dam, WIN4857ARegistered aircraftN-number assigned, not yet registeredN4857CGate Holdings LLC · Ketchum, IDN4857DMarkwood Bruce A · Anchorage, AKN4857GVero Technical Support Inc · Pensacola, FLN4857JWogan Ted E · Russellville, ALN4857LGlass Steven L · Knob Lick, KYN4857TWillis Donald H · Temple, TXN4857UColorado Aviators LLC · Gypsum, CON4857VNewsouth Aviation LLC · Auburn, ALN4858DRostron Kenneth E · Eagle Nest, NMN4858JSchapiro Stephen Alexander · Lambertville, NJN4858LSolis Moises G · Austin, TXN4858PGreat Plains Spraying Inc · Colby, KSN4858TGuerra Thomas C · Montgomery, TXN4858UD & D Adventures LLC · Cleveland, TXN4859ADory Lakota L · Caldwell, IDN4859CHanni Walter G · Anchorage, AKN4859FRidgway Stephen · Avon, CON4859GAirgo Inc · Centralia, ILN4859LDavinci Ventures Inc · Bolingbrook, ILN4859TRamirez-Pagan Abelardo · Copperas Cove, TXN485AArcher Aircraft LLC · Wilmington, DEN485ABPrice Scott · Camas, WAN485BCInter American University Of Puerto Rico · Bayamon, PRN485BLBlue Line Aviation LLC · Smithfield, NCN485CSundale Aviation Inc · Erwinna, PAN485CACivil Air Patrol · Maxwell Afb, ALN485EDSouthern Aircraft Consultancy Inc Trustee · Casper, WYN485GRegistered aircraftN485GAAlexander Glynn M · Miramar Beach, FLN485GBVergon Keith E · Osceola, INN485HPHigh Performance Aircraft LLC · El Cajon, CAN485JMSanders Flight Training Center Inc · Jasper, ALN485JSPlaskett Mark G · King City, CAN485MACunningham Richard · Justin, TXN485PBlackstone Stephen E · Southampton, NJN485SBLyddon Aero Center Inc · Liberal, KSN485SLPlrg LLC · Wilmington, DEN485SYYoung Todd N · Mechanicsville, VAN485TMitchell Lisa Marie · Lake Villa, ILN485VL & W Leasing LLC · Smyrna, TNN486Hagg Jeffrey D · Maysville, KYN4860AWolff Paul J · Baraboo, WIN4860DWeinheimer Jeffrey T · Onida, SDN4860UBoard Of Regents Of The University Of Oklahoma · Norman, OK
Back to AD 2007-04-19 R1