AD 85-02-05 R1
Registered aircraft · 8,920
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:85-02-05-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:85-02-05-R1')
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:85-02-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:85-02-05-R1') 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.
N6076DPinnow Andrew W · Cheshire, CTN6077DPargman Curtis A · Big Lake, MNN6078DWagar Dennis Murphy · Marion, MTN6079PColson Carl L · Blunt, SDN6079ZSimmons Aviation Services LLC · Pawcatuck, CTN6084CBig Bend Community College · Moses Lake, WAN6084DCsapos Larry G · Ovid, MIN6085YPharmair LLC · Jackson, MSN6087PBrandner Paul D · Lake Tapps, WAN6088DSale Reported · Langley, WASale reportedN6089DHoyt William C · Trimble, MON6089PMichaelsen Richard P · Sanborn, NYN6089YAerosavant LLC · Towanda, PAN6090PBasin Franchising LLC · Vernal, UTN6092YClean Waste Solutions LLC · Indianapolis, INN6097PGuest Aviation LLC · Crane Hill, ALN60CSAir Flight Enterprises Inc · South Daytona, FLN60LFNorthwoods Air LLC · Orono, MEN60MBCurry Arnold J · Houston, TXN60RBShrode Rafe C · Jewett, TXN60WFEngels John · Edmond, OKN60WUWsu Campus Of Applied Sciences And Technology · Wichita, KSN6100DSzostak Edward M · San Diego, CAN6101DHanson John A · Molena, GAN6101PLockett Terrell M Sr · Winter Haven, FLN6102DHutchins Chad M · Colorado Springs, CON6102PAllen Darren Kerr · Thomasville, GAN6104DLehrman Ronald L · Brownsburg, INN6104PKimsey Thomas W · Warner Robins, GAN6106PRegistration Pending · Mesa, AZRegistration pendingN6107DStephen Benjamin G · Egg Harbor, WIN6111DAdventure Flight LLC · Duchesne, UTN6112PBurnett Jennifer · Palmer, AKN6112ZLowry Wilson R · Leonardtown, MDN6114PCompton Mark E · Garfield, KYN6115DGeske Robert L · Enderlin, NDN6118DAtkinson James A · Bouse, AZN6118PNovak Mark S · Dawson, NEN6119DMeyer Robert M · Lancaster, NYN6119PModisette Jeremy W · Baldwin, GAN611SGRph Engineering LLC · Lehi, UTN611VProtain Jaden · Reno, NVN611WWCone S E Jr · Hobbs, NMN6120PDremel Ronald W · North Bend, PAN6120ZH & H Ag Aviation Inc · New Underwood, SDN6121PSmith Gloria M · New Hampton, NYN6121YWeaver Scott Allen · North Logan, UTN6123DCampi Curtis · Boulder City, NVN6125YDelaware Aircraft Trust LLC Trustee · New Castle, DEN6125ZSvendsen Jon A · Wasilla, AK
Back to AD 85-02-05 R1