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.
N28434S & S Aviation LLC · Lighthouse Point, FLN284382a0 Flyers LLC · Dayton, TNN2843AKnerr Joshua DBA · Tehachapi, CAN2843DHicks Adam B · Louisville, KYN2843MCar Store Inc · Honolulu, HIN2843RDrandike Aviation LLC · Scottsdale, AZN2843WJ & L Equipment Sales & Rental LLC · Andersonville, TNN2843YHarper Fred S · Springerville, AZN28446Snead Timothy G · Anacortes, WAN28448Kannarr Tracy A · Mesquite, NVFirst renewal noticeN2844ASmith Jon K · Adairville, KYN2844DMichigan Aeronautics Commission · Lansing, MIN2844FN2844f LLC 0421 · Valentine, NEN2844ML C C West LLC · Freehold, NJN2844PZiller Michael W · Hudson, ILN2844QReigle Aviation · Palmyra, PAN2844RBower Robert W · Scottsdale, AZN2844WPerformance Aircraft C LLC · Litchfield Park, AZN2844YChildress Hugh W · Ozona, TXN28454Martin Joseph S · Carrollton, KYN28455Souleret George R · Mechanicsville, VAN28458Payne Douglas E · Aiken, SCN2845RCarlson Kevin J · Dunedin, FLN2845YParis Air Inc · Vero Beach, FLN2845ZKrause Douglas F · Stacy, MNN28462Mountain Tiger Dzj LLC · Blairsville, GAN28463Teer David A · Hope Mills, NCN2846AUp And Up Aviation LLC · Magnolia, TXN2846FA-Z Aviation LLC · Bay City, MIN2846GSteel Aviation LLC · Valdosta, GAN2846NCrew Sourcing Inc · Wilmington, DEN2846PWilliamson Gary · Ashmore, ILN2846QStafford Richard J · Bayport, NYN2846RHaller Richard W · Cypress, TXN2846SBell Stephen R · Carleton, MIN2846TEdjs Holdings LLC · Gladewater, TXN2846WJohnson Daniel P · Williamsburg, IAN2846XJones John J · Fort Worth, TXN28470Skytypers Inc DBA · Las Vegas, NVN28476Loudoun Aviator Club Inc · Vienna, VAN28479York Jeffrey · Colorado Springs, CON2847AKozacek Carter A · Duluth, MNN2847QDobbelaere Craig M · Oakwood, OHN2847RCashman Jeremiah P · Bozeman, MTN2847YLott William R · Douglas, GAN2847ZRhodes Jacob H Jr · Lenoir, NCN2848Picerno John · Middle Island, NYN28483Forsgren Lyle M · Oshkosh, WIN28487Jcb Enterprise LLC · Wilmington, DEN2848ALitzen Guide Service Inc · Kenai, AK
Back to AD 2007-04-19 R1