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.
N83HAFly My Ultra LLC · Sellersburg, INN83ZAOp Partner Inc · Odessa, TXN84Federal Aviation Administration · Oklahoma City, OKN840AAD And S Western Holdings LLC · Garden City, TXN840BMJsj LLC · Wilmington, DEN840CTKeith Hammett LLC · Missoula, MTN841KYPinaire Holdings LLC · Hendersonville, TNN841MSSafari Intl LLC · Lewes, DEN843MLGlobal It Air LLC · Suwanee, GAN845ATApalach Adventures LLC · Chattanooga, TNN845BBN845bb Partners LLC · Richmond, VAN846BEM D Airways Inc · Derby, KSN847BABeech Transportation Inc · Eden Prairie, MNN848GAdmin Holdings LLC · Colleyville, TXN84CANeojet N84ca LLC · Reno, NVN84JHFlycarolina LLC · Concord, NCN84LGLanding Gear 7 LLC · Bossier City, LAN84XPF B T Services LLC · Portland, ORN850BKRpm Consulting LLC · Middletown, DEN850MACentral Aviation LLC · Sebring, FLN851HSCp Expansion 2 LLC · Little Rock, ARN851SHFlight Time LLC · Des Moines, IAN852HAAirspeed Aviation LLC · Millersburg, OHN852JPDavis Aviation Inc DBA · Brandon, MSN852SHFive Stallions LLC · Valley, NEN853ACSwihart Properties LLC · Roanoke, INN853CRVehicle Holdings Inc · Las Cruces, NMN854JAN854ja LLC · Walterboro, SCN856ACVision Jet LLC · Fort Wayne, INN858MEFlying Turtles Two LLC · Dallas, TXN858RMPnd Enterprises LLC · Sarasota, FLN85EBGt Commercial Interests LLC · Austin, TXN85HEMongoss Inc · Livingston, LAN85MSAviation Trust Company LLC Trustee · Oklahoma City, OKN85UTFly Mwm LLC · Kemah, TXN85WTExcalibur International Aviation Inc · Spring, TXN860CRGulf Atlantic Airways Inc · Gainesville, FLN860JAAirborne Aviation LLC · Miami, FLN8611RGeneral Energy Research Group · Conroe, TXN861ZGGeneral Energy Research Group · Conroe, TXN862HTSublett Holdings LLC · Wilmington, DEN862KN862k LLC · Houston, TXN863JBPj One LLC · Land O Lakes, FLN864HABravo Preferred Partners LLC · Solon, OHN867JCWoodbine Aviation LLC · Lewes, DEN867SLSafeco Leasing LLC · Port Alsworth, AKN868CWBig Sky Insulations Inc · Belgrade, MTN868RXAviation Trust Company LLC Trustee · Oklahoma City, OKN86PCLos Veranos Companies LLC · Irvine, CAN86URMsr Investment Properties LLC · Brentwood, TN
Back to AD 90-06-13