AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.
N6132VDorsey Russell R · Phoenix, AZN61330Holman Ricardo Earl · Creswell, ORN6133AReinders Monte M · Port Townsend, WAN6133DThomas Aviation · Granada Hills, CAN6133HCbc Aviation LLC · Hayden, IDN6133JArbello Danny · Sterling, VAN6133NSiesta Key LLC · Wilmington, DEN6134GMagruder David · Independence, LAN6134NChris Bellinger Dvm LLC · Newalla, OKN6134PJ-Tom Inc · Lincoln, NEN6134SPatten Jeffery D · Rapid City, SDN6134WRegistration Pending · Mesa, AZRegistration pendingN6135BOlds Todd · Huntersville, NCN6135DHowe Bryan · Edgewater, FLN6135WWhiskey Aviation LLC · Huntsville, ALN6136JTennessee Flight Academy LLC · Bristol, TNN6136KAll On Black LLC · Mount Nebo, WVN6136PPlane Fun Inc Tr Trustee · Snellville, GAN6137DPhelps Joe · Princeton, KYN6137EPennington Mitchell T · Medley, WVN6137JBradford III Properties LLC · Huntersville, NCN6137SPiasecki Aircraft Corp · Coatesville, PAN6137TDurnin Timothy K · Lansing, ILN6137WPrepmasters Inc · Boynton Beach, FLN61385Grady Will M · Gallatin, MON6138JLockwood Elijah T · Dayton, OHN6138VGlover Michael M · Mechanicsville, VAN6139AN6139a Corp Trustee · Wilmington, DEN6139WFleetwood James D · French Lick, INN613ADhs Operations LLC · Wilmington, DEN613ACBas Part Sales LLC · Greeley, CON613APThomas Lucas G · Beebe, ARN613BKMaxwell Roy J · Kenai, AKN613DBTigner Steven M · Leesburg, FLN613FPlane Fun Inc Tr Trustee · Snellville, GAN613FLOwens William N · Lexington, NCN613KBPrecision Aero LLC · Wilmington, DEN613LCostigan George J · Nashua, NHN613PCPrivitt Bret J · Forest Hill, TXN613RAKampa Arnold J · Vero Beach, FLN613RBFly Amphibious Aircraft LLC · Tampa, FLN613RVFlege Jordan T · Morrow, OHN613SCMorgan John P · Atlanta, GAN613SMWiff Robert A · Tahuya, WAN613SPAirmart Inc · Lexington, KYN613VTSky West Aviation Inc Trustee · Albuquerque, NMN613WKKnaust Jerry L · Blue Jay, CAN613XEMalinchak Louis · Bristow, OKN6140EIorio Jeffrey M · Tucson, AZN6140JWeldy Mark L · Etna Green, IN
Back to AD 87-10-06 R1