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.
N3236QBo'S Investments LLC · Amarillo, TXN3236THg Aviation LLC · Helena, MTN3236UHetrick Daniel R · Orovada, NVN3236ZJuliet Sierra Foxtrot LLC · Denver City, TXN32375Mersereau Austen D · Anchorage, AKN32376Delaware State University · Dover, DEN32378Sanders David D · Alvin, TXN32379Erkert Jason A · Phoenix, AZN3237NLee Leo Lea Young · Pasadena, CAN3237YCopper Mountain Assets · Winthrop, WAN32384Metz Justin · Scottsdale, AZN32386Rice Craig W · Walnut Creek, CAN32387Mclelland Brenda M · Springfield, MON3238AHawley Timothy J · Ashland, OHN3238DLutes Richard L · Hampshire, ILN3238ESwiss Jack S · Anchorage, AKN3238FKercheval Todd R · Georgetown, TXN3238QAttitude And Configuration Indicator LLC · Bedford, TXN3238RSublime Aerials LLC · Madison, WIN3238YKorff Aviation LLC · Leesburg, VAN3238ZZulu Flight LLC · Washougal, WAN32390Gruendling Kurt · Shelburne, VTN32392Devrnja Aero LLC · Knoxville, TNN32393Mcnamee James R · Cocoa, FLN32394Cherokee Wings LLC · Indialantic, FLN32397Tanya Austin L · Newburgh, NYN3239DJaj Flying LLC · Sutton, NEN3239ELeaf Air LLC · Queensbury, NYN3239Q92nd West Aviation Inc · Lonoke, ARN3239UJohnson Colten T · Richards, MON3239WHaidlen Ford Inc · Oakdale, CAN3239YHarper Mark A · Winston Salem, NCN3239ZRoach Aviation LLC · Longview, TXN323AGalloway Lyle R · Ashton, IDN323ACKing Ag Leasing Inc · Sudan, TXN323APEm Concordia Inc · Brooklyn, NYN323BETracy Brian R · Georgetown, OHN323BGElectric Cowboy Aviation LLC · Okeechobee, FLN323BTOlson Bryce T · Fertile, MNN323CAChatman Ira D · Mountain Home, ARN323CDMesibov Steven · Deland, FLN323CKHanrahan Sean K · Satellite Beach, FLN323CLHoge John · Setauket, NYN323CWAcorn Aerobatics LLC · Muskego, WIN323DProfessional Training Aircraft LLC · Wilmington, DEN323DASky West Aviation Inc Trustee · Albuquerque, NMN323DCFlymax Aircraft LLC · Ball Ground, GAN323DFKeir Thomas A · Hopatcong, NJN323DHKleinsmith Stacee F · Eagle River, AKN323DMWard Frank J · N Richland Hills, TX
Back to AD 2007-04-19 R1