AD 75-06-01
Registered aircraft · 2,832
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:75-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:75-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:75-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:75-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.
N290BCTraven Ricardo Siro · Georgetown, SCN290CCMonument Aviation LLC · North Chesterfield, VAN290PASouthern Aircraft Consultancy Inc Trustee · Casper, WYN291DFRmb Leasing Inc · Dover, DEN292KQNortheast Elite Aviation LLC · Oakland, MEN292PSteelman Aviation Inc · Las Vegas, NVN293KDKodiak Special LLC · Huntsville, ALN294DRValiair Lc Trustee · Casper, WYN294LARoma Air Corp · Belle Glade, FLN294TTUncommon Solutions LLC · Hollis, NHN294ZPCumulus Aviation Inc Trustee · Wilmington, DEN295DCHibiscus26 Inc Trustee · Wilmington, DEN297KDAir Sansone LLC · New Castle, DEN298KDKenmore Crew Leasing Inc Trustee · Bellingham, WAN299AVTeton Leasing LLC · Pocatello, IDN299CZN299cz LLC · Milwaukee, WIN299MKBoman & Kemp Manufacturing Inc · Ogden, UTN299RPGuardian Flight LLC · Lewisville, TXN299VMSs Leasing LLC · Tulare, CAN29ANSouth Aero Inc · Albuquerque, NMN29MBluesky Geospatial Ltd · North Adams, MAN29MGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN2AVRegistration Pending · Scottsdale, AZRegistration pendingN2GGN2gg Leasing LLC · Ponca City, OKN2MKItalian Job Holdings LLC · Johnstown, OHN30019O & K Aviation Inc · Newport, ARN3004WMiddle Georgia Aviation Inc · Cochran, GAN300AEColumbia Asset Trust Corp Trustee · Wichita, KSN300BFBasler Turbo Conversions LLC · Oshkosh, WIN300KAHeartland Aviation LLC · Ada, OKN300PTGjf Enterprises Inc · Port Orange, FLN300TMTaylor & Martin Enterprises Inc · Fremont, NEN300WJAthens Aviation LLC · Wilmington, DEN300WMWalker Manufacturing Co · Fort Collins, CON301CLWin Win Aviation Inc · Wake Forest, NCN302PSF90x LLC · Modesto, CAN30397Rust Raymond H III · Nacogdoches, TXN303GVState Of Alaska · Palmer, AKN303JWKey Investment Holdings LLC · Horseshoe Bay, TXN303RRG2 Leasing LLC · Fargo, NDN304JSRegistration Pending · Pharr, TXRegistration pendingN3051KBuilding Corp LLC · Huntsville, TXN3052KUas Transervices Inc · Boca Raton, FLN305ELRoper Aviation LLC · Wilmington, DEN3066WFortis Aircraft Leasing LLC · Reno, NVN307RWRomeo Whiskey LLC · Klamath Falls, ORN307SBSan Bernardino County Sheriffs Aviation Division · San Bernardino, CAN307YPVillages Equipment Co · Leesburg, FLN3080FGreyhawk Aviation LLC · Ketchum, IDN30898Painter Andrew S · Harlingen, TX
Back to AD 75-06-01