AD 2012-06-01
Registered aircraft · 726
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-06-01')
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-06-01')
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-06-01') 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-06-01') 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.
N654WAWinchester Air Inc · Winchester, MAN655QSNetjets Sales Inc · Oklahoma City, OKN655TXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN656CNCorporate Flight Management Incdba · Smyrna, TNN656QSRegistered aircraftN657CNCorporate Flight Management Inc · Smyrna, TNN664AFAlfa Financial Corp · Montgomery, ALN668TXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN669QSNetjets Sales Inc · Columbus, OHN670KF2012 Leasing Inc · Saint Paul, MNN670MWDg Financial Consulting Inc · Longview, TXN676TXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN678QSNetjets Sales Inc · Oklahoma City, OKN679LGBank Of Utah Trustee · Salt Lake City, UTN67PRStr Holdings LLC · Memphis, TNN681WAWonderful Orchards LLC · Bakersfield, CAN683QSNetjets Sales Inc · Columbus, OHN685QSNetjets Sales Inc · Oklahoma City, OKN686QSNetjets Sales Inc · Oklahoma City, OKN687SFTextron Aviation Inc · Wichita, KSN68GNGrady-White Boats Inc · Greenville, NCN68MYRedeemed Holdings II LLC · Artesia, NMN690MJNorth South Aviation LLC · Sheridan, WYN690TXKancolo Aero LLC · Wichita, KSN690XLLuke Oil Co Inc · Hobart, INN692TXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN693QSNetjets Sales Inc · Oklahoma City, OKN697ECEagle Carports Inc · Mount Airy, NCN697SDMia Jets Acquisitions LLC · Miami, FLN6TMO52 Logistics LLC · Mriott Sltrvl, UTN703PPink Ribbon Aviation LLC · Wilmington, DEN704HHHihopes Air LLC · Charlotte, NCN705SGUnion Of Operating Engineers · Pasadena, CAN706RRRr604 LLC · Charlotte, NCN706WLScheels All Sports Inc · Fargo, NDN708MBas Part Sales LLC · Greeley, CON708USXls Leasing LLC · Conover, NCN70BCSale Reported · Wilmington, DESale reportedN70THAlliance Aviation Group LLC · Wilmington, DEN711BSBlue Transport LLC · Columbia, SCN711FPF A Peinado LLC · Frisco, TXN711LXNational Education Loan Network Inc · Lincoln, NEN711LZBg22 LLC · Lewes, DEN712ABArcbest II Inc · Fort Smith, ARN712GKKs Air 3-7-12 Vi LLC · Charlotte, NCN712JNIp Aviation LLC · Saint Paul, MNN712PVTacocat LLC · Omaha, NEN713TXZeplane LLC · Miami, FLN714WAMustang Interests LLC · Fort Worth, TXN715MNCohasp Aero Ventures LLC · Overland Park, KS
Back to AD 2012-06-01