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.
N5138710fss - Usafa Aero Club · Usafa, CON51388Flight Line Resources Inc · Chandler, AZN5138DUrlaub James E II · Phoenix, AZN5138ESanders Flight Training Center Inc · Jasper, ALN5138LFlying Gators Inc · Overland Park, KSN5138RBell Ornithopters Flying Club Inc · Eastlake, CON5138SBarr Jerry L Jr · Mount Pleasant, TXN5138VAdvanced Charter & Instruction LLC · Costa Mesa, CAN51390Mustang Sally Aviation LLC · Camden, SCN51395Rush David A · El Dorado, KSN5139DEdwards A Clay · Weaverville, CAN5139EAero Techniques LLC · Binghamton, NYN5139LBrown Robert F · Sugarloaf Key, FLN5139QNykerk Kory · San Miguel, CAN5139UCoosa Valley Aviation Inc · Wilmington, DEN5139XGlatthaar Richard J · Burbank, WAN5139YB & B Equipment Inc · Cantwell, AKN513AFVee Two Inc · Merritt Island, FLN513AGPlane Fun Inc Tr Trustee · Snellville, GAN513BLWingsleasing LLC · Wichita, KSN513CTCoast Flight Training And Management Inc · San Diego, CAN513CWMurphy Ronald C Jr · Cocoa Beach, FLN513DWright Aero Inc · Saint Cloud, MNN513DNNowakowski Donald K Trustee · Gilbert, SCN513DRSternhagen Richard · Sweetwater, TNN513EREmbry-Riddle Aeronautical University Inc · Prescott, AZN513JCMathis Joshua D · Mitchell, INN513JSFox John R · Lansing, KSN513KXHart Aviation Enterprises LLC · Jonesboro, ARN513LAN318he LLC · Bulverde, TXN513LFLunken Flight Training Center LLC · Cincinnati, OHN513MSteuber Edward P · Erwin, TNN513MCWilliams Val · Victor, IDN513MMGlacier Peak Aviation LLC · Carnation, WAN513MSPark Brian Byung · Anaheim, CAN513NDAerosim Academy Inc · Sanford, FLN513PCBaklanov Sergey I · Whitestown, INN513PTLake Timothy Michael · Murfreesboro, TNN513PUBrosemer Kathleen M · Sault Sainte Marie, MIN513RCraddock Roger D · Memphis, TNN513RJGurski Robert C · Lees Summit, MON513RMRosen Larry M Trustee · Santa Barbara, CAN513SCInstant Whip Foods Inc · Columbus, OHN513SPPlane Old Inc · New York, NYN513TDWeber Sandra L · Simpsonville, SCN513TLN468ha Inc · Middletown, DEN513TRGonzalez Miguel A · Pembroke Pines, FLN513WFMeow Meow LLC · Seattle, WAN513ZPlain Nuts LLC · Dover, DEN513ZMBullard Aerospace Corp · Boston, MA
Back to AD 2007-04-19 R1