AD 2002-11-07
Registered aircraft · 1,512
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:2002-11-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-11-07')
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:2002-11-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-11-07') 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.
N1832WTailwinds Aviation LLC · Beechgrove, TNN18333Rjb Air LLC · Lexington, KYN18344Ab Aviation Sales & Rental LLC · Washington, DCN18351Iowa Great Lakes Flyers Ltd · Cheyenne, WYN18358Life Is A Beech LLC · Los Lunas, NMFirst renewal noticeN18360Anderson Julie A Trustee · Palo Alto, CAN18361Landvater Darryl V · Williston, VTN18363Bas Part Sales LLC · Greeley, CON18364Goeken Peter C · Dakota Dunes, SDN18386Gamco Aviation LLC · Shreveport, LAN18396Drec 0419 LLC · Carson, CAN18433J4 Aviation LLC · Lexington Park, MDN1843LRegistered aircraftN18475Gerlach And Associates LLC · Valparaiso, INN1847HQuantum Fly Corp · Boca Raton, FLN184MBBaker Aviation Consulting LLC · Summerland Key, FLN1850FMarcus Air LLC · Plano, TXN1852WDavis Sean · Carlisle, IAN1854RSellers William G III · Troy, ALN1858PBaron N1858p LLC · Fresno, CAN185ARortvedt Robert S · Mukwonago, WIN1865LLiberty Partners Inc · Okmulgee, OKN186VBLatb LLC · Lewes, DEN18748Board Of Trustees Of Southern Illinois Univ · Carbondale, ILN18752Morgantown Flying Club LLC · Morgantown, WVN1879LN1879l LLC · Missoula, MTN1889WSabre 65 LLC · Helena, MTN188WW3l0 Air LLC · Chuluota, FLN1895LPalm Group LLC · Metairie, LAN1896LGolf Lima Aviation LLC · Port Angeles, WAN189CRPelco Investments Inc · Wilmington, DEN18HMYoung Craig · Ada, MIN18SCSpencer Clyde V · Queen Creek, AZN18VJAssurance Data Inc · Indiana, PAN18VRVentura Air LLC · Wilmington, DEN1901LBerry Darrel · Camden, TNN190RSBas Part Sales LLC · Greeley, CON191LRRoutman Leone Aircraft LLC · Fort Lauderdale, FLN191WEFs Mickey LLC · East Lansing, MIN1973Registered aircraftN198BArkla Aviation LLC · Farmerville, LAN199PBSkyflite LLC · Hillsboro, ORN19ESRegistered aircraftN19FSCole Properties LLC · Foley, ALN19KYChi Yang · Lafayette, CON19RAAviatzone LLC · Fort Lauderdale, FLN1BFRussell Kellum LLC · Saratoga, CAN1MFWise Christopher J · Plano, TXN1MQGc4 Aero LLC · Birmingham, ALN1PZRegistered aircraft
Back to AD 2002-11-07