AD 90-06-13
Registered aircraft · 1,827
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:90-06-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:90-06-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:90-06-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:90-06-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.
N26HGNion LLC · New Century, KSN26HHApa Aviation LLC · Gainesville, FLN26QLUltra Leasing LLC · Fargo, NDN271SBVillains Airways LLC · Newark, DEN27TBBos Dairies LLC · Lake Havasu City, AZN280PMCommand Decisions Inc · San Angelo, TXN280RATechnology Service Corp · Arlington, VAN282HVN282hv LLC · Amarillo, TXN282LSJh Strain & Sons Inc · Tye, TXN283DFTexas Aircraft Parts Brokers LLC · Seguin, TXN284HSAxis Aviation LLC · Boerne, TXN284KMidsouth Air LLC · Lewes, DEN285CC3kd LLC · Wilmington, DEN285MCCypress Aviation LLC · Lyon, MSN288ATN38ry LLC · California, MDN288HLJbm Equipment Leasing LLC · Center, TXN28ELDodson International Parts Inc · Rantoul, KSN28LALv Air LLC · Lompoc, CAN28TXMidwest Flying Service Dos LLC · Sheldon, IAN28VUPhysicians Air Transport LLC · Hot Springs, ARN291PANorthrop Grumman Systems Corp · El Segundo, CAN294RTSouthland Equipment Services LLC · Cottondale, ALN299RBKing Air Partners LLC · Howe, OKN299RKGasser LLC · Midland, TXN29QCN560wp LLC · Portland, ORN2DBKa300 LLC · Greenwood Village, CON2GQ6 Echo November LLC · Murfreesboro, TNN2RCRico Marketing Corp · Flint, MIN2TWJuliett Papa LLC · Kalispell, MTN2UPTriton Aviation LLC · Evans, GAN300CHWorldwide Option LLC · Lewes, DEN300CWDome Aviation LLC · Loomis, CAN300GCN300gc LLC · Los Angeles, CAN300KLPeddinghaus Corp · Bradley, ILN300MCHighway 16 Ranch LLC · Corpus Christi, TXN300PTGjf Enterprises Inc · Port Orange, FLN300SEJetx Air LLC · Camden, DEN300TEKingair 61 LLC · Wilmington, DEN300TNWild Blue Aviation LLC · Wilmington, DEN300WBGarmin International Inc · Olathe, KSN300WJAthens Aviation LLC · Wilmington, DEN300WMWalker Manufacturing Co · Fort Collins, CON300WQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN301CWSky 005 LLC · Colorado Springs, CON301WYOrion Air Holdings LLC · Cheyenne, WYN302PSF90x LLC · Modesto, CAN302SJSendero Aviation LLC · Houston, TXN302WCCst Management LLC · Pflugerville, TXN303CJLand Of Indiana Inc · Bedford, INN303CPDjh1 LLC · Liberty Township, OH
Back to AD 90-06-13