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.
N629FFAllen Teinert Construction Co · Lubbock, TXN629MDAircraft Holding Solutions LLC Trustee · Newark, DEN62TLDialysis Clinic Inc · Nashville, TNN630SPAircraft Holding Solutions LLC Trustee · Newark, DEN630TKN630tk LLC · Clovis, NMN631TSLettuce Fly LLC · King City, CAN632GUFlyarnd LLC · Tyler, TXN633ATNrx Pharmaceuticals Inc · Wilmington, DEN633PCDjd Aero LLC · Lubbock, TXN633RSTsc Logistics LLC · Destin, FLN63593Rbr Development LLC · West Plains, MON637ATN637at LLC · Punta Gorda, FLN638GMSkytrain Aviation LLC · Dallas, TXN63FFFuntime63ff LLC · Bozeman, MTN63FXTrn Aviation LLC · Lewes, DEN63JG63jg LLC · Colorado Springs, CON63JTLiberty Flight Co LLC · Jonesboro, ARN63RAEncore Aviation LLC · Indian Trail, NCN63RSTeewinot Aviation LLC · Jackson, WYN63TKBeaver N63tk LLC · Salem, ORN640RBTalfin Leasing II LLC · Heflin, ALN640YBluebonnet Aviation Club LLC · San Marcos, TXN641TSLifewings II LLC · Harrisonville, MON643RTOld Glory Leasing LLC · Fargo, NDN646DRWilderness Aircraft Co LLC · Bloomington, MNN648ASale Reported · Chicago, ILSale reportedN649JCDeja Air LLC · Morristown, TNN64FTTennison Bryan · Aledo, TXN64LVDitch Diggers Aviation LLC · Lisle, ILN64RT64rt LLC · Birmingham, ALN64SVR S & I Inc · Idaho Falls, IDN64TFParatus Jets LLC · Auburn, INN650ABBank Of Utah Trustee · Salt Lake City, UTN650ACTen X Express LLC · Fort Myers, FLN650AHNice Trip LLC · San Juan, PRN650ASRegistration Pending · Clermont, FLRegistration pendingN650ATN650at LLC · Punta Gorda, FLN650CBSzucs Attila · Port Orange, FLN650CGC G Bretting Manufacturing Co Inc · Ashland, WIN650CJViggiano Aviation LLC · New Haven, INN650CMYc Equipment Co LLC · Orangeburg, SCN650CZTeam Aero LLC · Shawnee, KSN650FCOrion Igv LLC · Opa-Locka, FLN650GCBank Of Utah Trustee · Salt Lake City, UTN650HGHamlin Aviation LLC · Ormond Beach, FLN650JAAircraft Guaranty Corp Trustee · Oklahoma City, OKN650JLEncore Jet Management LLC · San Antonio, TXN650KPJt95 Airways LLC · Concord, CAN650NVNion LLC · New Century, KSN650PFAircraft Holding Solutions LLC Trustee · Newark, DE
Back to AD 90-06-13