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.
N6839RGolden Wings LLC · Tampa, FLN683DMMcmorphy LLC · Erie, PAN683SRTf Global LLC · Houston, TXN684BCRegistered aircraftN684CDFreedom Development Corporation LLC · Matthews, NCN684DMMidwest Aviation Equipment LLC · Solon, IAN684SRPelair LLC · Milton, DEN685CDGraves Koene R Trustee · Paso Robles, CAN685DMMetcalf Steven · West Union, IAN685SRRegistration Pending · Seattle, WARegistration pendingN6869RPro Air Media LLC · Sevierville, TNN686DSScheigert Delbert F Jr · Saint Cloud, FLN687PWDragonflier LLC · Las Vegas, NVN688PDUnusual Attitudes LLC · Bates City, MON688SRRsm Enterprises LLC · Helena, MTN68BARegistered aircraftN68DXFreeman David J · Seattle, WAN68GTBoon Hong Sim · New York, NYN68GYOwll Aviation LLC · Baton Rouge, LAN68PFWooden Steve S Trustee · Nokomis, FLN68SYFreeman William M · Cameron Park, CAN690NDAltitude Adjustment LLC · Lisle, ILN690SRAircraft Guaranty Corp Trustee · Oklahoma City, OKN691TSAl Systems Corp · Weston, FLN6935LBreidenbach Aviation LLC · Bettendorf, IAN693CLin Steven C · Granite Falls, NCN693CDAber Air LLC · Amherst, OHN693CPCharlie Papa 1 LLC · Stafford, TXN693JDBowles Brent K · Lake Jackson, TXN693MSandpiper Air LLC · Alexandria, VAN693SRCarmichael Mark G · Palm Desert, CAN693TFStevenson Farhana · Lexington, MAN693TSColtharp William M · Austin, TXN694CDRogers Jack Burton Jr · Bakersfield, CAN694MRHarmon Creighton D · Scott, LAN694PRAdvanced Charter Industries LLC · Orange, CAN694TTMiller Patrick · Riverside, CAN6950TThornebymyside LLC · Punta Gorda, FLN696PGCirrus Sr22 3606 Inc Trustee · Wilmington, DEN697CMrc Aviation LLC · Columbia, TNN697CBPaul L W Smith Inc · Kingston, GAN697SRSouthern Aircraft Consultancy Inc Trustee · Casper, WYN698ESSund Lloyd · Kramer, NDN699CDFaridev LLC · White Plains, NYN69MZHall John · Litchfield Park, AZN69PKBiofusion LLC · Fort Smith, ARN69YKMetal Wholesale LLC · Bloomfield, IAN69ZAMoleno Capital LLC · Dallas, TXN6BGMollica Air LLC · North Andover, MAN6CACra Aviation LLC · Dickerson, MD
Back to AD 2007-24-13