Skip to content

Registered aircraft · 72,001

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

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

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.

N1UKPenn Flight School LLC · Quakertown, PABuilt 1977 · S/N 28-7790564 N1VKChupito Sabrocito LLC · Paso Robles, CABuilt 1960 · S/N TD-403 N1WUN1wu LLC · Loganville, GABuilt 1966 · S/N 30-1383 N1WYBultron Cristina · Ocala, FLBuilt 1964 · S/N 24-4018 N1XACowell Aviation Maintenance LLC · Easley, SCBuilt 1964 · S/N 24-3599 N1XCTarheel Aeroplanes LLC · Macclesfield, NCBuilt 1956 · S/N 207-245 N1XGClass A Coaches LLC · Missoula, MTBuilt 1981 · S/N 1001 N1XXLewis James · Los Angeles, CABuilt 1973 · S/N JC1 N1YBPerry Billy Mac Jr · Monument, COS/N 3152 N1ZAEisaguirre Joseph M · Anchorage, AKBuilt 1959 · S/N 18-7002 N1ZEAdkins Gordon L · Kenova, WVBuilt 2002 · S/N 24088 N1ZYDavis Harold · Houston, TXBuilt 1994 · S/N 2805 N20005Lmbi Inc · Sierra Vista, AZBuilt 1972 · S/N 17260923 N20008Crabdree Marty D · Conroe, TXBuilt 1977 · S/N 17702621 N20009Moore Douglas R · Garfield, GABuilt 1972 · S/N 17260926 N2000HMartinez Edgar · Houston, TXBuilt 1974 · S/N AA5-0625 N20011Fulmer Robert A · Irvine, CAS/N W-1 N20012Hester Edward R · Bladenboro, NCS/N 17260929 N20014Wines Ira · Tuscarora, NVBuilt 1972 · S/N 17260930 N20015Airplanes And Attitude LLC · Mckinney, TXBuilt 1972 · S/N 17260931 N20018Aerofeather Aviation Inc · Suffolk, VAS/N 17260934 N20019Mccall Freddie W · Brewton, ALBuilt 1972 · S/N 17260935 N2001LSeventh LLC · Summerfield, FLBuilt 1966 · S/N 334 N20020Nuanes Dane Scott · Missoula, MTBuilt 2007 · S/N 72393 N20023Usnick Robert W · Mc Donald, PABuilt 1977 · S/N 17702622 N20025Golden Eagle 025 LLC · Cary, NCBuilt 1972 · S/N 17260941 N20026Leatherman Randal A · Fairplay, MDBuilt 1972 · S/N 17260942 N20029Kedrowski Daniel J · Ham Lake, MNBuilt 1972 · S/N 17260944 N2002TGodfrey Guy M · Tampa, FLBuilt 1969 · S/N 2 N2002VDay William S · Anchorage, AKBuilt 1979 · S/N F-142 N20031Bulman Erik D · Kailua, HIBuilt 1972 · S/N 17260946 N20032Noone Robert T · Glencoe, ALBuilt 1972 · S/N 17260947 N20033Coddiwomple LLC · Newberg, ORBuilt 1972 · S/N 17260948 N20038Kimmel Tara L · Cloquet, MNBuilt 1972 · S/N 17260951 N20039Kcsi Aerial Patrol Inc · Bakersfield, CABuilt 1972 · S/N 17260952 N2003EHarman Dane P · Halifax, PABuilt 1978 · S/N 17271116 N2003MRoyal Timothy G · Apex, NCBuilt 1977 · S/N 28-7890221 N2003PPhilyaw Larry L · Pontiac, ILBuilt 1956 · S/N 23-572 N2003SDanner Robert L · Wisconsin Dells, WIBuilt 2002 · S/N 1140 N20040Victor Francois · Carrollton, TXBuilt 1972 · S/N 17260953 N20041Wings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 17260954 N20045Massey Travel LLC · Ozark, MOBuilt 1972 · S/N 17260958 N20046Blue Panda LLC · Olive Branch, MSBuilt 1972 · S/N 17260959 N20047Flying Broke Acres LLC · Lexington, NEBuilt 1972 · S/N 17260960 N20050Florida Keys Flight Academy LLC · Marathon, FLBuilt 1972 · S/N 17260962 N20051Hayek Pierre N · Alta Loma, CABuilt 1972 · S/N 17260963 N20053Spanaflight LLC · Puyallup, WABuilt 1972 · S/N 17260965 N20055Chesley Laurence J · Valdez, AKBuilt 1972 · S/N 17260967 N20056Haney Randall M · Boaz, ALBuilt 1977 · S/N 17702624 N20057Opiela Robert M · Hampton, NHBuilt 1972 · S/N 17260969

Back to AD 87-10-06 R1