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.
N550BJLybl Air 2 LLC · Portland, ORN550BMMareth Management Inc · Monett, MON550CFMidwest Jet LLC · Marshall, MNN550CGCsc Delaware Trust Co Trustee · Wilmington, DEN550CTGroup Two LLC · North Dinwiddie, VAN550CZMldg Aviation LLC · Warden, WAN550DCM A / F H Aviation Inc · Dayton, OHN550DLMmch Aerospace LLC · Goshen, INN550DSMetro Aviation Inc · Shreveport, LAN550FPJk Aircraft Options LLC · Aripeka, FLN550GLGaba Zero Seven LLC · Beaumont, TXN550GZFlybynight LLC · Imperial, CAN550HCVasquez Jimmy · Carlsbad, NMN550HHGlobal Aircraft Trust Inc Trustee · Cheyenne, WYN550HJBravo II LLC · Carmel, INN550HKGlass City Leasing LLC · Perrysburg, OHN550JMayes John · Carson City, NVN550JXN918vc Corp · Wilmington, DEN550MJMidwest Jet LLC · Lynd, MNN550MLDjp Properties LLC · Selma, CAN550MNBarkley Air LLC · Scottsboro, ALN550MZN550mz LLC · Omaha, NEN550NBSkies The Limit LLC · Raleigh, NCN550NTAllied Asset Management LLC · Oklahoma City, OKN550PFExecutive Business Travel LLC · Wilmington, DEN550RBUrban Wings LLC · San Antonio, TXN550RMReal X Jet LLC · Sarasota, FLN550RZN550rz LLC · Saint James City, FLN550SCX Air Flight Support LLC · Uvalde, TXN550SFN550sf LLC · Nashville, TNN550SGNunya LLC · Irvine, CAN550SKAfp Travel LLC · Waco, TXN550SSHorgan Enterprises LLC · Newport Beach, CAN550TNTruenorth Companies Lc · Cedar Rapids, IAN550TRSpringfield Air Inc · Kansas City, MON550TWJoveros Aviation LLC · Wilmington, DEN550TYMidwest Jet LLC · Marshall, MNN550VGJ Industries LLC · Lewes, DEN550WDWoodbine Aviation LLC · Lewes, DEN550WEInformation Alpha LLC · St Thomas, VIN550WJSale Reported · Weston, FLSale reported, pending cancellationN550WKLegacy Jets LLC · Francesville, INN550WRN550wr LLC · Lawton, OKN550WSFlores Enterprises 22 LLC · Weslaco, TXN550WTTwined LLC · Hendersonville, TNN550ZSLh Jet Aviation LLC · Honey Brook, PAN551BCRadar Rider LLC · Kissimmee, FLN551CZBrig Air 2 LLC · Birmingham, MIN551DAAerotrust Services Corp Trustee · Wilmington, DEN551GENw Miles Air LLC · Tualatin, OR
Back to AD 90-06-13