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.
N604PJJere Aviation LLC · Fond Du Lac, WIN605JYN524ma Inc · Wilmington, DEN6069AAt Aero LLC · Wilmington, DEN607JYAlvarez Jorge · Miami Springs, FLN608BCSteiner Gp LLC · Weatherford, TXN608CEEmb Aviation LLC · Tulsa, OKN608CTHuf Aviation LLC · Waxahachie, TXN609MTValiair Lc Trustee · Casper, WYN60FTSuper II LLC · Austin, TXN610RSRsc 1972 LLC · Valdosta, GAFirst renewal noticeN6110Solidwood Aviation Express LLC · Waller, TXN611ATN611at LLC · Punta Gorda, FLN611GSGable S Corp · West Linn, ORN611VGEncore Motors Of Melbourne Inc · Melbourne, FLN612VRWorldwide Option LLC · Lewes, DEN614AJFoyt Aviation LLC · Waller, TXN614CPInternational Aircraft Marketing & Sales LLC · Sarasota, FLN614JKUniversal Pacific Investment Corp · Portland, ORN615AJPaloma Air LLC · Santa Maria, CAN615HRAjv Aviation Holdings LLC · Venice, FLN616NEWarmont Company · Midland, TXN616RPCapling Aviation LLC · Labelle, FLN616TGYucaipa Aviation Inc · Alvarado, TXN618JGChris Jenschke LLC · Poteet, TXN618KCiholas Aviation LLC · Newburgh, INN618LKRvr Air Charter LLC · Fort Worth, TXN619GNBank Of Utah Trustee · Salt Lake City, UTN619HPLofty Group LLC · Carmel, CAN61AYAonvo Investment LLC · North Miami, FLN61CSLone Star Aviators LLC · Houston, TXN61GKOverdrive Aviation LLC · Cantonment, FLN61HTCentral Virginia Aviation Inc · North Dinwiddie, VAN61THBlue Heron Aviation LLC · Orwigsburg, PAN621AFBright Skies Mt LLC · Kalispell, MTN621JGWhite Aviation LLC · Ashford, ALN621KMEjair LLC · Conway, ARN622KMK & M Equipment Co LLC · Chatsworth, CAN622PGCapital Craft LLC · Wilmington, DEN622PMChoice Aviation LLC · San Antonio, TXN622TFN9cr LLC · Hilton Head Island, SCN623BGRrkj Aviation LLC · Cave Springs, ARN623PMLal Holdings LLC · Gallatin, TNN624PLLow Tide LLC · Riverside, IAN624PWK3m Leasing LLC · Tyler, TXN625ACAir Fiber LLC · Black Rock, ARN625WAPhoenix Helicopters LLC · Dover, DEN626RBMillard Robert B · Stratford, CTN627BCHard Eight Investments LLC · Alpharetta, GAN627MGMile High Adventures LLC · Yazoo City, MSN628GBMmx LLC · Chesapeake, VA
Back to AD 90-06-13