AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N151CDAloha Helicopter Tours LLC · Lihue, HIN151CHGharazeddine Raja · Kaplan, LAN151CPSale Reported · Millersville, MDSale reportedN151DB1 Zero Sierra Whisky LLC · Helena, MTN151DLBd Aviation LLC · Sauget, ILN151GAtp Aircraft 9 LLC · Wilmington, DEN151JLLuebben John R · Sun City West, AZN151JSPerkins E G Jr · Greenwood, MSN151KCAir Flite Inc · Shawnee, OKN151LTBoss Dog LLC · Sheridan, WYN151MELoweth William A · Noank, CTN151MSEisenbaum Jeffrey S · Ashland, ORN151NAMht Aviation LLC · Saint Petersburg, FLN151PAIntermountain Fabrication LLC · Jerome, IDN151PCWear Thomas M · Bridgewater, NJN151SAKennedy Jon P · Gillette, WYN151SLChambers Scott K · Aurora, ORN151STWildman Lake Lodge Inc · Anchorage, AKN151TLAlpine Air Alaska LLC · Girdwood, AKN151VJonathan Wise & Associates Inc · Edmond, OKN151VUVincennes University · Indianapolis, INN152Donahoe Wiliam B Trustee · Willis, TXN1520Littler David E · Largo, FLN15200Cash Warren A · Loveland, CON15201Quaintance Kemper A · Culpeper, VAN15204Arthur Jeffery L · Lima, OHN15207Tiburon Aviation LLC · Tampa, FLN15208Colorado Northwestern Community College · Rangely, CON1520RCastro Jose M · Conway, ARN1520TAaa Aero LLC · Glenwood, MNN15215Curtis David W · Watertown, NYN15219Shoup Michael D · Pierre, SDN1521RPerkins J R III · The Dalles, ORN15222Southeast Aircraft Leasing LLC · Jacksonville, FLN15223Dobson Anthony Eric · Alexandria, VAN15224Ludlow Reba J · Ponte Vedra Beach, FLN15226Blackwell Stephen E · Burlington, NCN15227Plank James M · Sarasota, FLN1522RN1522r LLC · Mequon, WIN1522XSpayd Charles M · Indianapolis, INN15238Shme II LLC · West Lakeland, MNN1523RDement Myers Michael W · Newberg, ORN15240Mitchell Joseph B · Westfield, MAN15242Bluclouds LLC · Kirkland, WAN15246Flightgest Academy LLC · Morrisville, NCN15247Flight Solutions Unlimited LLC · Bloomington, MNN15248Greer Daniel · Murrieta, CAN15250Sedberry Jason A DBA · Kokomo, INN15251Thompson Roger C · Herndon, VAN15255Elizabeth City State University · Elizabeth City, NC
Back to AD 2006-10-21