AD 2007-24-13
Registered aircraft · 4,026
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-24-13')
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-24-13')
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-24-13') 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-24-13') 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.
N229RMMjt Real Estate Holdings LLC · Orlando, FLN229SG229sc LLC · Fayetteville, GAN22ADMorganav Inc · Chapel Hill, NCN22AYRegistration Pending · Lebanon, PARegistration pendingN22CE0 To 100 Aviation LLC · Palmetto Bay, FLN22CYHughes Jason David · Hickory, NCN22DBSalisbury Mark J · Green Cove Springs, FLN22DMM1 Aviation LLC · Trenton, NJFirst renewal noticeN22EGEsm Aviation LLC · Pomona, NYN22FARosen Barry W · West Hollywood, CAN22GXKiser Raymond Paul · Sebring, FLN22KHTrue Aviation LLC · Charlottesville, VAN22VCVictorcharlie LLC · Weston, MAN22VGGreenway Group LLC · Suwanee, GAN22WEWings Over Saluda Institute LLC · Wilmington, DEN22WXCisneros Corina · Belmont, NHN22XDNokes James · Woodbury, TNN22XJSmile Air LLC · Vidalia, GAN22ZFEastern Stearman Inc Trustee · Leesburg, VAN22ZMAbkw Air Sunshine LLC · Wilmington, DEN230CARinehart Investment Group LLC · Forest Lake, MNN230EValiair Ltd Co Trustee · Casper, WYN230SRNational Auto Solutions LLC · Gallatin, TNN230WJCenter Ice Scouting LLC · Crestwood, KYN231LLTen-Xray LLC · Woodside, NYN231WMA Davtian M D Medical Services Inc DBA · Glendale, CAN232CDNew Paul · Jackson, TNN232FJConstruct Air LLC · Osage Beach, MON232MMBuilder Tony Hirst LLC · Kittrell, NCN232SRRegistration Pending · Vandalia, OHRegistration pendingN233LSSelznick Larry Trustee · Stevenson Ranch, CAN233MMHigh Way LLC · Wilmington, DEN233NCEnergyview LLC · Tioga, NDN233SBC2c LLC · Hamilton, MTN233SROharra Robert J · Buckley, WAN233WZInduction Aviation LLC · Lewes, DEN234AKKihneman David J · Spring, TXN234BJJmc Commercial Contractors LLC · Porter, TXN234CWWright Caleb · Douglas, GAN234CZBank Of Utah Trustee · Salt Lake City, UTN234DPConnect 4 Ventures LLC · Woodberry Forest, VAN234ETAir Fergie LLC · Camden, DEN234HKExplore Aviation LLC · Santa Barbara, CAN234JFaliero Bryan K · Greenville, SCN234LBCirrus Design Corp · Duluth, MNN234PDAccurite Machine & Manufacturing Inc · Louisville, KYN234PGSpeer Aircraft LLC · Evansville, INN234XLCirrus Design Corp · Duluth, MNN235SKInde Aviation LLC · Chesterfield, VAN236DCGilbert Gerald · Falls Church, VA
Back to AD 2007-24-13