AD 2012-10-13
Registered aircraft · 13,306
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:2012-10-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:2012-10-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:2012-10-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:2012-10-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.
N899SStocks Aviation And Machine Inc · Wilmington, DEN899TJN988tj LLC · Okemos, MIN899TTTangtang Gang LLC · Lewes, DEN89ABSkybound Escapes LLC · Daniel Island, SCN89ADClairmont Holdings Vi LLC · St Thomas, VIN89BGPegasus Ltd LLC · Farmington, ILN89BPBlackfin Aviation LLC · West Islip, NYN89BTCrow Wing III LLC · Palm Beach, FLN89CRWsg Aviation LLC · Chaffee, MON89EPBas Part Sales LLC · Greeley, CON89FJS-Turns LLC · Windermere, FLN89GHSouthern Aircraft Consultancy Inc Trustee · Casper, WYN89HWHw Air Lc · Salt Lake City, UTN89KBJet Sense Aviation Aircraft Holdings Corp · Burlington, WIN89KPRegistered aircraftN89KWThelen Mark C · Roswell, GAN89MNNoffze Michael · West Fargo, NDN89NBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN89NXCardinal Account Services Inc DBA · Mentor, OHN89PBPb Mad Aviation LLC · Pittsburgh, PAN89PFBrown Jeffrey T · Sherman, ILN89SNRegistered aircraftN89SWRaw Dog Aviation And Media LLC · Naples, FLN89UMIsbell Services LLC · Tuscaloosa, ALN89WGCirruslysoaring LLC · Carmel, INN8APacific Aviation LLC · Cottage Grove, ORN8ADChelsea Build LLC · Brenham, TXN8AEIflyu LLC · Mobile, ALN8BLPro One Janitorial Inc · Chicken, AKN8CCMag 3 Aviation LLC · Vidor, TXN8DADrenk Aviation LLC · Fountain Valley, CAN8EYMoore Robert Russel Sr · Austin, TXN8FBRichland Aviation Inc · Sidney, MTN8FMSky Dawg LLC · Winterville, NCN8KMWolding Jeffrey D · Ashland, WIN8KTChui Aviation LLC · The Woodlands, TXN8KXTroutman Shaun L · Johnson, KSN8LJFlying Mushrooms LLC · New York, NYN8LUMoes Nose Holdings LLC · Washington, DCN8MXMoncrief Rick L · Melba, IDN8NURbc Aviation LLC · Hollywood, FLN8SGSouthern Cross Aircraft LLC · Fort Lauderdale, FLN8SSWeather Modification LLC · Fargo, NDN8SZFinch Stanley F · San Marcos, TXN8TMAdvanced Intelligent Computing Inc DBA · Houston, TXN8URLoberg Kirk · Jonesboro, ARN8UZAerospace Trust Management LLC Trustee · Wilmington, DEN8WT8wt LLC · Manakin Sabot, VAN8WWLcam Aviation LLC · Springfield, MON8WYStockhouse James B · Jackson, WY
Back to AD 2012-10-13