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.
N681PGRspd-Air LLC · High Point, NCN681RCObsidian Air LLC · Pompano Beach, FLN681SRegistered aircraftN681SGResa Group LLC · Brunswick, GAN6822UKw Aircraft LLC · Judson, TXN68233Sunbird Aviation Inc · Bozeman, MTN68236Vaughn Air LLC · Hillsboro, ORN68239Northeast Skywagon LLC · Pittsfield, MEN6823DS A Fliers LLC · Venice, FLN6823FTreetop Aviation LLC · Wilson, NCN68245Registration Pending · Anderson, SCRegistration pendingN6824LEnvironmental Evolutions Transportation Inc · Robstown, TXN6825TSongbird Aviation LLC · Larkspur, CAN6826BDan Howard Aircraft Sales LLC · Tulsa, OKN6826LThomas Faulhaber Pc · La Veta, CON6826QBeechcraft Heritage Museum · Tullahoma, TNN6827LDuke Aviation LLC · Woodridge, ILN6828PSnowfox Insurance Inc · Pace, FLN6828RDaves Aircraft LLC · Eden, NCN6829WGroupe Caraibe LLC · Wilmington, DEN682CDFly Tlc LLC · Dexter, MON682JDWindward Air LLC · Orlando, FLN682JSIflyhigh LLC · Phoenix, AZN682RMHuebel Ross · Houston, TXN682SRMajdalani Maher J · Perrysburg, OHN682VCCotham Victor S · Saint John, INN6830LN661w Air LLC · Dalton, GAN6830WRocket Airways LLC · Verona, WIN6834APlum Family Buildings LLC · Marengo, IAN68379Express Carrier LLC · St Thomas, VIN6838XOcean Flight Corp · Weston, FLN68391Hyannis Air Service Inc DBA · Hyannis, MAN6839RGolden Wings LLC · Tampa, FLN6839YRichland Aviation Inc · Sidney, MTN683DMMcmorphy LLC · Erie, PAN683SDMurray Steven L · Webster, NYN683SRTf Global LLC · Houston, TXN683TM007 Arkansas Aviation LLC · Jonesboro, ARN6846CDillon T34 6846c LLC · Scottsdale, AZN684BCRegistered aircraftN684CABrown Luke · Center, TXN684CDFreedom Development Corporation LLC · Matthews, NCN684DMMidwest Aviation Equipment LLC · Solon, IAN684LGGold Aircraft Leasing LLC · Fort Lauderdale, FLN684SSecond Wind Aviation Corp · Friday Harbor, WAN684SRPelair LLC · Milton, DEN6850BJennings Donald J · Gypsum, CON6855RD & N Holdings Inc · Boca Raton, FLN685CDGraves Koene R Trustee · Paso Robles, CAN685CPSouthern Aircraft Consultancy Inc Trustee · Casper, WY
Back to AD 2012-10-13