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.
N54105Gopub Aviation Inc Trustee · Wilmington, DEN54175Aircraft Guaranty Corp Trustee · Oklahoma City, OKN5419WKenosha Aviation LLC · Jacksonville, FLN541CDAcheson Wiliam B · Waconia, MNN541DFSr20 Holdings LLC · Coral Springs, FLN541JDBlue Sky Flyers LLC · Hoover, ALN541SRSierom LLC · Charlotte, NCN541WPStorzer Daniel Norman · Neenah, WIN542AMSolid Rock Stone Inc · Shady Point, OKN542CDStorch David · Goodyear, AZN542PFKittyhog Air LLC · Margate, FLN542PGMountain Airplane LLC · Alpine, WYN542SFNoble Aviators LLC · Myrtle Beach, SCN542SRAlliance Solutions Group Inc · Yorktown, VAN543FCGraytail Vision LLC · Dallas, TXN543GWBrown Gregory L · Argyle, TXN543LKKilolima3 LLC · Washington, DCN543MWWood Martin J · Ramona, CAN543SKGreene Scott P · El Paso, TXN544CDAeroplanes LLC · Cary, NCN545CBRegistered aircraftN545CDValiair Lc Trustee · Casper, WYN545CP545 Charlie Papa LLC · Colorado Springs, CON545PMPerseverance Enterprises LLC · Sitka, AKN545WTBuilding Restoration Corp · Roseville, MNN546CDScalini Fernando A · Huntington Beach, CAN546KMAero Montana LLC · Greensboro, GAN547CHoch Jeffrey · Seattle, WAN547DTMcb Family Aviation LLC · Boca Raton, FLN547SMTrinity Aviation LLC · Rome, GAN548CPF Partnoy Inc · San Diego, CAN548EBRomeo Charlie Aircraft Partners LLC · North Little Rock, ARN548RESabair LLC · Clinton, PAN549CDValiair Limited Co Trustee · Casper, WYN549SRPlane Fun Flying Club · Vancouver, WAN54KYGael Aviation Inc · West Harrison, NYN54LGSynergy Wellness Group Inc · Bakersfield, CAN54LWDogtown Aviation LLC · Teton Village, WYN54VL4791 Capital Holdings LLC · Austin, TXN54WFMajmudar Krupal · Flemington, NJN550CDCoen Scott D · Kingsport, TNN550RGBr Ventures LLC · Port Orange, FLN551ATCorellian Spacecraft LLC · Leesburg, VAN551BPPalmer John Michael · Saint Louis, MON551CDBwr Group LLC · Hobbs, NMN551SGAviation Module LLC · Los Angeles, CAN551SRN551sr Aviation LLC · Roswell, GAN552CDDirect Internet Inc · Harsens Islands, MIN552FSSciortino Frank M · Oswego, NYN552SRGenung Tobin J · Ocala, FL
Back to AD 2007-24-13