Skip to content

Registered aircraft · 20,687

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-06-03-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-06-03-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-06-03-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-06-03-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-06-03-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-06-03-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.

N8211LWelch James J · Salisbury, NCBuilt 1967 · S/N 17256411 N8212BSeven Delta Whiskey Club · Brush Prairie, WABuilt 1957 · S/N 36012 N8212LVersaw Charles J · Center, COBuilt 1967 · S/N 17256412 N8212XMonahan Linda J · Groveland, CABuilt 1961 · S/N 17248712 N8213LTraining Planes LLC · Tampa, FLBuilt 1967 · S/N 17256413 N8213UJohnson Matthew K · Paducah, KYBuilt 1964 · S/N 17252113 N82149Sanders Flight Training Center Inc · Jasper, ALBuilt 1976 · S/N 17267692 N8214UN8214u LLC · Sheridan, ARBuilt 1964 · S/N 17252114 N8214XStroemsvik Kristian · Strasburg, VABuilt 1961 · S/N 17248714 N8215LUmphrey Reid · Douglasville, GABuilt 1967 · S/N 17256415 N8215XLaforest Jerome P · White Lake, MIBuilt 1961 · S/N 17248715 N8216BBrezina Chad M · Whitewright, TXBuilt 1957 · S/N 36016 N8216LWoodworth Mark S · Madison, OHBuilt 1967 · S/N 17256416 N8216UClinch Jerome J · Lincoln, NEBuilt 1964 · S/N 17252116 N8216XRiver Town Aviation LLC · Williamstown, WVS/N 17248716 N8217BRoll George N · Freeport, FLBuilt 1957 · S/N 36017 N8217LSteward Kim R · Durand, ILBuilt 1967 · S/N 17256417 N8217XRiggs John · Punta Gorda, FLBuilt 1961 · S/N 17248717 N8218LTufts Kyle J · Hampden, MEBuilt 1967 · S/N 17256418 N8218USalley Ronald C · Satellite Beach, FLBuilt 1964 · S/N 17252118 N8218XEvans James · Millbrae, CAS/N 17248718 N8219UShaffer Kenneth H · Trout Lake, WABuilt 1964 · S/N 17252119 N8219VGreenman Lisa J · Chesterton, INBuilt 1956 · S/N 29884 N8219XCouch James T · Choctaw, OKBuilt 1961 · S/N 17248719 N821EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2021 · S/N 172S12665 N821RMC&C Aero LLC · Billings, MTBuilt 1967 · S/N 17256414 N821SDGlobal Adventures N821sd LLC · Hollywood, FLBuilt 1985 · S/N 172-76485 N821STNorthwestern Michigan College · Traverse City, MIBuilt 2021 · S/N 172S12772 N8220BTurner Travis Joseph · Chetek, WIS/N 36020 N8220LFlywyo LLC · Kalispell, MTBuilt 1967 · S/N 17256420 N8220XGundry James A · Fall Creek, WIBuilt 1961 · S/N 17248720 N8221BMayberry Jonathan J · Lake Stevens, WABuilt 1957 · S/N 36021 N8221LAntholz John C · Apple Valley, MNBuilt 1967 · S/N 17256421 N8221XPegasus Endeavors LLC · Kalispell, MTBuilt 1961 · S/N 17248721 N8222LSimpson Roger E Sr · Moncks Corner, SCBuilt 1967 · S/N 17256422 N8222UCramer Bill · Oxnard, CABuilt 1964 · S/N 17252122 N8222XFoster Neal W · Nome, AKBuilt 1961 · S/N 17248722 N8223LO'Connor Aidan J · East Moriches, NYBuilt 1967 · S/N 17256423 N8223UChapter 36 Flying Club Inc · Hagerstown, MDBuilt 1964 · S/N 17252123 N8224LCamp Lake Aircraft LLC · Salem Lakes, WIBuilt 1967 · S/N 17256424 N8224UPlane Fun Inc Tr Trustee · Snellville, GABuilt 1964 · S/N 17252124 N8225BConner Mark Wes · Thomasville, NCBuilt 1957 · S/N 36025 N8225LWebb George Q · Monroe, GAS/N 17256425 N8226BPerez Emanuel A · Calistoga, CABuilt 1957 · S/N 36026 N8227BSegovia Nicholas A · Mooresville, NCBuilt 1957 · S/N 36027 N8227UGeiger Russell K · Hilliard, FLBuilt 1964 · S/N 17252127 N8227XMitchell Randall Dean · New Hampton, IABuilt 1961 · S/N 17248727 N8228Cross John · Canton, OHBuilt 1965 · S/N 17252520 N8229BPittman Rex A · Haskell, TXBuilt 1957 · S/N 36029 N8229LWuest Steven D · Ripon, WIBuilt 1967 · S/N 17256429

Back to AD 90-06-03 R1