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.
N501GLSharp Aviation LLC · Pauls Valley, OKN501GTPollux Aviation Ltd · Wasilla, AKN501HLAarow Aircraft Leasing LLC · Mcminnville, ORN501JAAlongi John J · Downers Grove, ILN501KPWasson Ronald L · Colleyville, TXN501LFMilchev Valentin · New Hampton, NHN501MAContinental Aerospace Technologies Inc · Mobile, ALN501MERoby Gregory Carl · Owensboro, KYN501MLVotava Paul A · Mcintosh, MNN501MPManzoor Khan · Stockton, CAN501NANasa Langley Research Center · Hampton, VAN501NGCummings Johnny R IV · Clearwater, FLN501PFTraumflieger LLC · Lancaster, PAN501PLDick Timothy R · Fox Lake, ILN501RADalton Charles · Auburn, NYN501RDBackcountry Endeavours LLC · Dassel, MNN501REIndependence Aerospace LLC · Kennesaw, GAN501RVSaunders Steven M · Elizabeth City, NCN501SBStevenson Randall J · Wildwood, MON501SCSaz Dynamics LLC · Daly City, CAN501SDNordeen Christopher L · Salinas, CAN501SFNomarco Inc · Woodburn, ORN501SGMccair LLC · Mineral Wells, TXN501TCCourtney Aviation LLC · Columbia, CAN501TSFlying Tigers Flight School LLC · Houston, TXN501UAlba Leasing Services LLC · Scottsdale, AZN501WPTrue Course Aviation LLC · Ashville, NYN501WTPeterson Floyd M · Lago Vista, TXN501ZNorth Georgia Helicopters Inc · Calhoun, GAN50208Haus Jesse M · Fort Worth, TXN5020DSpiro Paul M · Anchorage, AKN5020HBorreson Anthony · Mariposa, CAN5020PThurston Steven C · Salisbury, NCN5020QHudson Thomas C Jr · Bessemer, ALN5020RMigliaccio Jason · Palm Bay, FLN5020SSchneider Robert R · Fort Benton, MTN5020TBetlach Christopher Thomas · Kenmore, WAN5020WAndersen Richard W · Vail, AZN5020YStandridge Robert M · Norman, OKN5021HAlamo Flyers LLC · Elmendorf, TXN5021JIntegrity Aviation LLC · Coatesville, INN5021RWax Sally G · Louisville, KYN5022DSearey 806 LLC · Weirsdale, FLN5022KElkins William S · Santa Fe, NMN5022WHovendick William P · Lander, WYN50233Garofalo Dawn L · Bellingham, WAN5023EHarned William C · Lebanon Junction, KYN5023FCharlie Tango Enterprises LLC · Newport Beach, CAN5023JTexas State Technical College · Waco, TXN5023LIsland Hoppers Seaplanes 2 LLC · Orlando, FL
Back to AD 2007-04-19 R1