AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N168DPJohnson Eldridge Jr · Chicago, ILN168DSVertx Fleet Holdings LLC · San Diego, CAN168FReading Aero Club Inc · Reading, PAN168FSWhitley Pat · Altoona, ALN168GTN168gt LLC · Newbury Park, CAN168KWWalsh Home Improvement Co Inc · Berlin, MDN168LHFarmingdale State College · Farmingdale, NYN168RBChristensen Hans P · Enterprize, UTN168TAKj Aviation Holdings LLC · Chesterfield, MIN168TCVan Bortel Aircraft Inc · Arlington, TXN168XBook Paul A · Richvale, CAN168YMewmew Investment II LLC · Palo Alto, CAN1690LBas Part Sales LLC · Greeley, CON1691MMesser Richard J · Olean, NYN1693RLeap Aviation Inc · Wilmington, DEN16956Hollowell Baron J · Boise, IDN1695RLehne Michael · Portland, ORN1696RMoore Alan · Glenwood, ARN1697R & W Aviation LLC · Owasso, OKN1698JFastglass Aviation LLC · Fenton, MON1698RRussell Robert Q · Genoa City, WIN1699RMacdonald Eric J · Belleville, MIN169ABSouthern Cub And Aircraft Restoration LLC · Pensacola, FLN169AGSkywest Leasing Inc · St George, UTN169BDFun Flying LLC · Riverwoods, ILN169BTAtkison Keith · Centre, ALN169BWFarris Frederick J · Sandpoint, IDN169CBGiuffre Vi LLC · Milwaukee, WIN169CCFtt Op!! LLC · Reno, NVN169CSChavi LLC · Fredericksburg, TXN169DBFrench David D · Tallahassee, FLN169DMMost Toys Wins LLC · Joliet, ILN169ETerrell Joe W III · Anchorage, AKN169ECFirst Eclipse Limited · Richmond, VAN169EXFlying Squirrel Aviation LLC · Wilmington, DEN169JPBoggs Mitchell · La Russell, MON169JRHull Terri L · Weirsdale, FLN169LHFarmingdale State College · Farmingdale, NYN169LPLcc East LLC · Freehold, NJN169MGeorge Michael · Springfield, ILN169MECc Aviation Inc · Tracy, CAN169MJPlane Metrics LLC · Fort Worth, TXN169PXXing Kong Aviation Service LLC · Atwater, CAN169SHEaa Aviation Foundation Inc · Oshkosh, WIN169TSkybolt 3 LLC · Arvada, CON169TRParker Timothy N · Socorro, NMN169XTalos Aeronautics LLC · Marion, TXN16AHendrix Aviation LLC · Benton, ARN16ABMasselink Ross W · Whitewater, KSN16AKGriffin Steven M · Enterprise, AL
Back to AD 2006-10-21