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.
N503PWellsprings Aviation LLC · Winston Salem, NCN503RMKa200 LLC · Jacksonville, NCN504CCFirst Port Air Inc · Omaha, NEN504RWYingling Aircraft LLC · Wichita, KSN504TAviationiq LLC · Helena, MTN504USunshine Airways Of N O LLC · New Orleans, LAN505MSCessna Aircraft Leasing LLC · Daytona Beach, FLN505RHHondo Aviation LLC · Roswell, NMN506PDDodson International Parts Inc · Rantoul, KSN506RWPapa Foxtrot Charlie LLC · Atascadero, CAN507BEM P Leasing LLC · Vermillion, MNN507ECSiilats Keith Trustee · New York, NYN507PDGr Aviation LLC · Saint Louis, MON508KDAero Air Charter Holding LLC · Pensacola, FLN508RZGeaux Flight LLC · Baton Rouge, LAN508SKMagnolia Logistics Of Ms LLC · Flowood, MSN509RPRonald A Peterson Inc DBA · Orlando, FLN50CMWizard Aviation LLC · Redding, CAN50ELSesa Aviation LLC · Weslaco, TXN50LQCu V LLC · Stuart, FLN50NBLexington Air Services LLC · Lexington, MSN50TW17 Aviation LLC · Oklahoma City, OKN50USN50us LLC · New Orleans, LAN50VSCitation Time LLC · Seguin, TXN50WRfbc LLC · Macon, GAN510CNC & N Aviation LLC · Coshocton, OHN510GPCentral Virginia Aviation Inc · Petersburg, VAN510JCMiller Timber Services Inc · Philomath, ORN510JNCu IV LLC · Stuart, FLN510SDChg Jets LLC · Orange, CAN511ABSl Jet LLC · Franklin, NCN513TSGully Air LLC · College Station, TXN513WTL L Express LLC · Wilmington, DEN515MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN518MVAzalea Connection LLC · Columbus, OHN518NGtt LLC · Panama City Beach, FLN518TXSav Aviation LLC · Jacksonville, TXN519DBN519db LLC · Dover, DEN519RJAircraft Holding Solutions LLC Trustee · Newark, DEN519VPCatalyst Aviation II LLC · Pensacola, FLN51DACentral Virginia Aviation Inc · Petersburg, VAN51JVSky Global LLC · San Juan, PRN51NDN51nd Holding LLC · Palm City, FLN520AJAction Jet Aviation LLC · Woodland Hills, CAN520BPToy Air Inc · Southfield, MIN520DDThomas Asset Group Ltd · Springtown, TXN520MCBedrock LLC · Anniston, ALN521LFThin Air Associates LLC · Pottsville, PAN521TMN521tm LLC · Eagle, IDN521VPMoo Too 1 Inc · Middletown, DE
Back to AD 90-06-13