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.
N585FDWoodbine Aviation LLC · Lewes, DEN585KSSaai.Com LLC · Miami, FLN585KTSadler Trevor Trustee · ProvidencialesNon-citizen corporation, flight hours not reportedN585RBPonderosa Aviation LLC · Safford, AZN587TWAircraft Security Corp · Laredo, TXN588ACBlu Bird Consulting Services LLC · Burnet, TXN588FPJk Aircraft Options LLC · Aripeka, FLN588JKJk Aircraft Options LLC · Saint Petersburg, FLN589AWBank Of Utah Trustee · Salt Lake City, UTN589FPJk Aircraft Options LLC · Aripeka, FLN589HHAccelgf Inc · Reno, NVN58DRocketman Rocketeers Lc · Austin, TXN590AKt Aviation LLC · Las Cruces, NMN590FPJk Aircraft Options LLC · Aripeka, FLN591DKIron Ring Aviation LLC · Portland, ORN591FPJk Aircraft Options LLC · Aripeka, FLN592FPJk Aircraft Options LLC · Aripeka, FLN592MABg LLC · Bozeman, MTN592VPKracum Laura T Trustee · Miami, FLN593FPJk Aircraft Options LLC · Hernando Beach, FLN593GGCircle S Air LLC · Wilmington, DEN594FPJk Aircraft Options LLC · Hernando Beach, FLN594WPGolden Leaf Tobacco Company Inc · Keysville, VAN595DCChoice Aviation LLC · San Antonio, TXN595KWGeronimo Aviation LLC · Burlison, TNN595RMAntelope Valley Community College District · Lancaster, CAN597AFMoondream 5 LLC · Cypress, TXN597MMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN598KWRegistered aircraftN599ARBank Of Utah Trustee · Salt Lake City, UTN599KDEncore One LLC · Conway, ARN59DFRlc Partners LLC · Grand Prairie, TXN59FTSt Andrews Aircraft LLC · West Palm Beach, FLN59GBTh Leasing Corp · Wilmington, DEN5PXRed Poodles LLC · Boston, MAN5STDe Paz Aviation LLC · Coral Gables, FLN5TRN535j LLC · Bismarck, NDN5UUFlid Aviation LLC · Birmingham, ALN5WCMidstar Transport LLC · Midland, TXN5WTShell Air LLC · Liberty Township, OHN600ATHarlow Cattle LLC · Dallas, TXN600BWLambert Mcguire Management LLC · Austin, TXN600EAEstancia Aviation LLC · Reno, NVN600HWSafe Adventures LLC · North Miami, FLN600TBFleet Aircorp Inc · Fort Lauderdale, FLN601BCAir Prive Solutions LLC · Miami Beach, FLN601CBCj1 LLC · Carmel, INN601CWFree Bird Aviation LLC · Ridgeland, MSN602ATOdl Partners LLC · Oklahoma City, OKN603DWOnarco2 LLC · Maurice, IA
Back to AD 90-06-13