AD 2007-10-01
Registered aircraft · 245
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-10-01')
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-10-01')
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-10-01') 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-10-01') 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.
N3087KBank Of Utah Trustee · Salt Lake City, UTN310KPLowry Flying Service Inc · Grinnell, IAN312FBFarm Brothers Flyers A LLC · Gould, ARN319HCThree Flying Monkeys LLC · Sunray, TXN325BGTurrell Flying Service Inc · Turrell, ARN373FBFarm Brothers Flyers A LLC · Gould, ARN392FBFarm Brothers Flyers A LLC · Gould, ARN392LAC&L Holzwarth Inc · Virden, ILN392TMCentral Farmer'S Cooperative DBA · Ville Platte, LAN394TMWebb Flying Service Inc · Coy, ARN398RKAir Worthy Inc · Lyon, MSN4012JCentral Iowa Agricultural Aviation LLC · Wellsburg, IAN4025MSky Tech Inc · Dorchester, NEN411GRLake Air Service LLC · Jennings, LAN411GSWoodley Aerial Leasing LLC · Walnut, ILN41588Echo Fox Leasing LLC · Wilmington, DEN41600Patriot Ag Air LLC · Huntington, INN41651Bank Of Utah Trustee · Salt Lake City, UTN419TWMidwest Agri Drone LLC · Saint Joseph, MON42022Central Iowa Agricultural Aviation LLC · Wellsburg, IAN4212JCentral Iowa Agricultural Aviation LLC · Wellsburg, IAN4217WAviation Flying Service · Greenwood, MSN422TWSug-Air LLC · Lubbock, TXN424FSOver And Under Flying Service Inc · Knox, INN42505Holloway Air Service Inc · Merigold, MSN42590Twin County Air-Ag Inc · Winnie, TXN437VADelta Air Inc · Belzoni, MSN438LADownstown Airport Inc · Vineland, NJN442MAMeyers Air Service LLC · Superior, NEN4512JCentral Iowa Agricultural Aviation LLC · Wellsburg, IAN4515JLowry Flying Service Inc · Grinnell, IAN455PAMcginty Flying Service LLC · Jones, LAN456LAJaj Flying LLC · Sutton, NEN4612JCentral Iowa Agricultural Aviation LLC · Wellsburg, IAN4712JCentral Iowa Agricultural Aviation LLC · Wellsburg, IAN496JBBank Of Utah Trustee · Salt Lake City, UTN49PAState Exchange Bank · Lamont, OKN5003XJagco Inc · Middletown, DEN50050Mowata Farms LLC · Mamou, LAN5005KFisher Spray Service LLC · Cardington, OHN5006GBank Of Utah Trustee · Salt Lake City, UTN5015KBirddog Aviation LLC · Stockton, KSN5021UReed Aviation Inc · Iota, LAN5043DSterling John A · Port Lavaca, TXN5045SAw Peterson Inc · Warren, MNN5048DFitchs Flying Service LLC · Pearsall, TXN50669Tri Rotor Spray And Chemical · Ulysses, KSN5070HKubecka Operating Company Inc · Seminole, TXN50738Farm Air Inc · Astoria, ILN507FAGarrett Flying Service Inc · Danbury, TX
Back to AD 2007-10-01