Skip to content

Registered aircraft · 68,375

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:90-04-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:90-04-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:90-04-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:90-04-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:90-04-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:90-04-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.

N3581ATriflyer Partners LLC · Garden Plain, KSS/N 22-1856 N3581BSpink Todd A · Mesquite, TXBuilt 1954 · S/N CH-41 N3581KVick Michael S · Camden, ALBuilt 1967 · S/N 28-23639 N3581QQuantie Harold G · Locust Grove, OKBuilt 1973 · S/N 17261681 N35821Coachair Inc · Groveland, CABuilt 1976 · S/N 177RG1056 N3582ASindelar David C · Franklin, KYBuilt 1953 · S/N 22-1857 N3582KPine Point Aviation LLC · Sartell, MNBuilt 1967 · S/N 28-23641 N35833Williams David Wayne · Ivins, UTBuilt 1976 · S/N 177RG1057 N3583ZHanneman Logan L · Fairbanks, AKBuilt 1960 · S/N 18-7373 N3584Dart Gregory G · Mayville, NYBuilt 1970 · S/N 36230 N35849Gilliam Robert L · Islamorada, FLBuilt 1976 · S/N 177RG1060 N3584KWilliamson Conner James · Hernando, FLBuilt 1967 · S/N 28-23643 N3584MBurcham Aaron T · Soldotna, AKBuilt 1947 · S/N 12-2431 N3584PWatson Frank D · Canton, PABuilt 1955 · S/N 18-4538 N3584ZWildman Air LLC · Mckinney, TXBuilt 1960 · S/N 18-7374 N3585Coon Donald N · Shedd, ORBuilt 2003 · S/N 25365 N35850Willke Ronald S · Edgewood, TXBuilt 1976 · S/N 177RG1061 N35852Taylor Bruce D · Cedar Rapids, IAFirst renewal noticeS/N 177RG1062 N35855Merritt Daniel D · Graham, WABuilt 1941 · S/N 6623 N35858Watkins Rickar D · Roseburg, ORBuilt 1976 · S/N 177RG1063 N3585AClement Jeffrey A · Abilene, TXBuilt 1953 · S/N 20-1085 N3585MHanlin Dale E · Porter, TXBuilt 1978 · S/N 28R-7837126 N3585QLerner Daniel A · East Durham, NYBuilt 1973 · S/N 17261685 N35866Terry Kayla · Moulton, ALBuilt 1976 · S/N 177RG1065 N35869Cardinal Flyers LLC · Moriches, NYBuilt 1976 · S/N 177RG1067 N3586MKoskovich Thomas D · Shakopee, MNBuilt 1947 · S/N 12-2509 N35872Kurtz David Lee · Cordele, GABuilt 1976 · S/N 177RG1068 N35873Mcgraw Charles F · Reno, NVBuilt 1941 · S/N 6638 N35879Aldrich Brad · Driftwood, TXBuilt 1976 · S/N 177RG1069 N3587LVanatta J Dennis · Faribault, MNBuilt 1978 · S/N 0809 N3587QBerger Donald D · Ilwaco, WABuilt 1973 · S/N 17261687 N3587XFlynn Sean C · Torrance, CABuilt 1968 · S/N 680156 N35884Dake Tech Consulting Inc · San Dimas, CAS/N 177RG1070 N3588PLewis' Flying & Maintenance Svc Inc · Morse, LABuilt 1955 · S/N 18-4543 N3589Sale Reported · Lonoke, ARSale reported, pending cancellationBuilt 1970 · S/N 680 N35896Brads Red Eye Auto Distributing LLC · Boise, IDBuilt 2003 · S/N 87M N3589KClark Joseph D · Kilgore, TXBuilt 1967 · S/N 28-23646 N3589PNewsom Bearden And Cobb Inc DBA · Lubbock, TXBuilt 1955 · S/N 18-4544 N3589QHalfpap Rodney J · Quincy, ILBuilt 1973 · S/N 17261689 N358BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2024 · S/N 2881806 N358CAFreeman Braxton L · West Lebanon, NHBuilt 1989 · S/N 2841283 N358CFApm Leasing LLC · Casper, WYBuilt 1978 · S/N 44-7995115 N358GAtp Taa LLC · Wilmington, DEBuilt 2020 · S/N 2881428 N358GWMihelebach Gustav · Lancaster, KYBuilt 2000 · S/N 358 N358JCDuran Peter F · Mesa, AZBuilt 1993 · S/N 058B N358MMatuska Douglas G · Kent, WABuilt 1999 · S/N 20913 N358MKNorth Star Aviation · Mankato, MNBuilt 2022 · S/N 2881524 N358RVDerby Kevin R · Clearwater, FLBuilt 1998 · S/N 22173 N358RWHawley Elizabeth B · Wichita Falls, TXBuilt 1979 · S/N AA5B1066 N358SPIscovich Angel L · Santa Barbara, CABuilt 1997 · S/N 22468

Back to AD 90-04-06 R1