Skip to content

Registered aircraft · 54,015

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-20-03-R2') 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-20-03-R2') 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-20-03-R2')
    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-20-03-R2')
  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-20-03-R2')
  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-20-03-R2')
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.

N7182EShoreline Consulting Inc · Bryan, TXBuilt 1959 · S/N 52182 N7182GBar-Od-4 Cattle Co LLC · Laredo, TXBuilt 1969 · S/N 17258882 N7182MThayer Stephen Claude · High Point, NCBuilt 1958 · S/N 55482 N7182QMullins Albert A · Boling, TXS/N 18267345 N7182SHoward William M · Greensburg, PABuilt 1967 · S/N 15067882 N7182TTdp LLC · Caldwell, IDBuilt 1959 · S/N 46782 N71831Kellogg Morgan · Missoula, MTBuilt 1969 · S/N 18259771 N71833Vega Al · Windsor, CAS/N 18259772 N7183AElk & Ram Aviation Group LLC · San Antonio, TXBuilt 1956 · S/N 29283 N7183FN7183f LLC · Spanish Fork, UTBuilt 1966 · S/N 15063783 N7183MSnavely Deborah B · Lake Placid, FLBuilt 1958 · S/N 55483 N7183QFlying Wild LLC · Yarmouth, MEBuilt 1972 · S/N 17260483 N71844Rusinsky Michael John · Amagansett, NYBuilt 1969 · S/N 18259775 N71846C3 Aviation LLC · Eustis, FLBuilt 1969 · S/N 18259776 N7184AGarrison Randy L · Queen City, TXBuilt 1956 · S/N 29284 N7184FYoke Aviation LLC · Bowling Green, KYBuilt 1966 · S/N 15063784 N7184QHolubar Properties Inc · Mckinney, TXBuilt 1973 · S/N 18262045 N7184SCade Steven V · Lopez, WABuilt 1967 · S/N 15067884 N7184THelderman Laban W · Newton, NCS/N 46784 N7185ENenadic John P · Camas, WABuilt 1959 · S/N 52185 N7185GJones Mark R · Denton, MDS/N 17258885 N71860Young Reginald L · Fort Worth, TXBuilt 1969 · S/N 18259783 N71866Lkn Skylane LLC · Mooresville, NCBuilt 1969 · S/N 18259785 N71867Friend Troy L · Wyandotte, OKBuilt 1969 · S/N 18259786 N7186AValiair Lc Trustee · Casper, WYBuilt 1956 · S/N 29286 N7186CRegistered aircraftBuilt 1973 · S/N 680 N7186SEagle Equity Inc · Valparaiso, INBuilt 1967 · S/N 15067886 N7186XSmith Calvin E · North Augusta, SCS/N 15059286 N71876Rasmussen Paul · Long Lake, NYBuilt 1969 · S/N 18259788 N71879Sale Reported · Greeley, COSale reported, pending cancellationBuilt 1969 · S/N 18259789 N7187AHannah David W · Richmond, TXBuilt 1956 · S/N 29287 N7187CWoldt Wayne E · Raymond, NEBuilt 1973 · S/N 681 N7187FHoranzy Paul S · N Grosvenordl, CTBuilt 1966 · S/N 15063787 N7187QChestnut Ridge Flying Club · Latrobe, PABuilt 1972 · S/N 17260487 N71880Meeks Michael D · Marion, TXBuilt 1969 · S/N 18259790 N71884Smith John L Trustee · Zephyr Cove, NVBuilt 1969 · S/N 18259792 N7188CUniversity Of Kansas · Lawrence, KSS/N 683 N7188EWashick Timothy J · South Lake Tahoe, CABuilt 1959 · S/N 52188 N7188FCopeland Lance Andrew · Jacksonville, ARBuilt 1966 · S/N 15063788 N7188GVrechek Joseph D · Fort Lauderdale, FLS/N 17258888 N7188MFilter Keith Jr · Lake Havasu City, AZS/N 55488 N7188QToles Chad · Austin, TXFirst renewal noticeBuilt 1972 · S/N 17260488 N7188XSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1961 · S/N 15059288 N71890Rich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1969 · S/N 18259794 N71896Silver Eagles Flying Club Inc · Armonk, NYBuilt 1969 · S/N 18259795 N7189APierson Janice R Trustee · Scio, ORBuilt 1956 · S/N 29289 N7189FTello Ricardo · Mission, TXBuilt 1966 · S/N 15063789 N7189GSky Hawk Flying Club · Grand Rapids, MNBuilt 1969 · S/N 17258889 N7189QMontgomery Paul · Fredericksburg, VABuilt 1972 · S/N 17260489 N7189XZephyr Air Corp · Dellwood, MNBuilt 1961 · S/N 15059289

Back to AD 87-20-03 R2