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.
N222LDHrt Aviation LLC · Charleston, SCN222SRC & C Air LLC · Cumming, GAN222XJBismarck Aircraft Owners Llp · Mandan, NDN222YYMerlin Aviation LLC · Fairfield, CTN223BMCirrus 801ca LLC · Port Angeles, WAN223ERKern Delta Co LLC · Fresno, CAN223FDRegistered aircraftN223GBMain Line Aviation LLC · Haverford, PAN223GKGk Aviation LLC · Orlando, FLN223HHMach Speed Properties LLC · Spiro, OKN223MKKaul Mahendra · Bainbridge Island, WAN223MRConderet LLC · New York, NYFirst renewal noticeN223RWRegistered aircraftN223TFMeadowlark Air LLC · Johnston, IAN223TNGeneral Aviation Modifications Inc · Ada, OKN223TSJvgh LLC · Eastpoint, FLN223TXBaron Logistics LLC · Metairie, LAN2242WKikhtenko Dmytro · Horse Shoe, NCN2246HHanover Flying Club LLC · Mechanicsville, VAN2247RSkaggs Erik Jerome · Tupelo, MSN224ARAvtac Solutions LLC · Oneida, TNN224AVAirplanesusa LLC · Schaumburg, ILN224BGSlo Cal Aviation LLC · Arroyo Grande, CAN224BTCacchiotti Lawrence F · Yakima, WAN224CESouthern Aircraft Consultancy Inc Trustee · Casper, WYN224CFTitan Land Company LLC · Medford, ORN224CZTeal Skies LLC · Wilmington, DEN224DAAiralley LLC · Kingsport, TNN224DDDe Maio Dorian Albert · Las Vegas, NVN224DGFahrer Scott M · Sunrise Beach, MON224EBVasquez Aviation LLC · Lake Placid, FLN224EJGlenn Air LLC · Ponte Vedra Beach, FLN224FRVictor 93 LLC · Hummelstown, PAN224GRHaufe Nicole C · Madeira Beach, FLN224HFHallock Scott A Sr · Oneida, TNN224JC109 Ventures & Agency Services Inc · Glenburn, MEN224JF224jf LLC · Waterford, MIN224JGGuillory Mark T · Pineville, LAN224KRJds Holdings LLC · Oneida, TNN224LRCamp95 Enterprises LLC · Wheeling, WVN224LZMazzia Aviation Partners LLC · Alpine, WYN224MVAircraft Guaranty Corp Trustee · Oklahoma City, OKN224NHLola Leasing LLC · Sugar Land, TXN224NXNexair Avionics LLC · Plymouth, MAN224PBDeaux James · Collierville, TNN224PCCarlson Craig B Trustee · Los Altos, CAN224PFKurrle Ryan J · Austin, TXN224PJLeng Jason W · Chehalis, WAN224RCSky West Aviation Inc Trustee · Albuquerque, NMN224RJDuke Mfg Of Florida LLC · Saint Louis, MO
Back to AD 2007-24-13