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.

N6337AAilf Marketing LLC · Port Charlotte, FLS/N 33137 N6337BMckee Bradley Cole · Taylor, TXBuilt 1957 · S/N 34237 N6337DHomerace Inc DBA · Tulsa, OKBuilt 1979 · S/N 17272723 N6337VFirelight Ventures LLC · Fuquay Varina, NCBuilt 1980 · S/N 172RG0633 N63384Sa Kim J · Hayward, CABuilt 1975 · S/N 15077274 N6338ALittle Bird Airways LLC · Hamburg, NYBuilt 1956 · S/N 33138 N6338BSlad George W · Albuquerque, NMBuilt 1957 · S/N 34238 N6338EBarber Theodore C Trustee · Spanish Fork, UTBuilt 1959 · S/N 46438 N6338FRaritan Valley Flying School · Princeton, NJBuilt 1979 · S/N 17273195 N6338GEron Patrick · Hatley, WIBuilt 1970 · S/N 15071838 N6338KBurchinal Sam F · Brookston, TXBuilt 1975 · S/N 15077652 N63395Reiman Jeffrey Scott · Chandler, AZBuilt 1975 · S/N 15077282 N63399Vogt Gerald J · Erie, PABuilt 1975 · S/N 15077284 N6339AHockenberry Tyler F · Royse City, TXBuilt 1956 · S/N 33139 N6339CBowles Donald E Jr · Dallas, TXBuilt 1980 · S/N 21063871 N6339DContrails II Inc · Kerrville, TXS/N 17272725 N6339EJudge Nathan E · Coeur D Alene, IDBuilt 1959 · S/N 46439 N6339MFlight World Inc · San Juan, PRBuilt 1980 · S/N 15284680 N6339SDamico Thomas J · West Bend, WIBuilt 1967 · S/N 15067139 N6339TRj Aircraft LLC · Vandling, PABuilt 1984 · S/N R18201986 N633BCOneal Brittany H · Palestine, TXS/N 17274633 N633DAAviation Systems And Service LLC · Mounds, OKBuilt 1974 · S/N 17702214 N633MTMajor Air LLC · Charleston, SCBuilt 1976 · S/N 17267904 N633WGWings Of Grace Ministries Inc · Melbourne, FLBuilt 1968 · S/N 17256670 N63401Evans Harold M · Dunnellon, FLBuilt 1975 · S/N 15077286 N63406Searfoss Robert L · Atlanta, GABuilt 1975 · S/N 15077290 N63407Mcguire Ryan · Redwood City, CABuilt 1975 · S/N 15077291 N6340EAdams Mandy Reed · New Braunfels, TXBuilt 1959 · S/N 46440 N6340FCommonwealth Of Massachusetts · Plymouth, MABuilt 1975 · S/N 18264165 N63412Knh Aviation LLC · Yuma, AZBuilt 1975 · S/N 15077294 N63414Simonis Kenneth W · Girdwood, AKBuilt 1975 · S/N 15077296 N63418Knutson Wayne R · Tioga, NDBuilt 1975 · S/N 15077299 N6341APattison Jeffrey L · Glasgow, MTS/N 33141 N6341EHansen'S Garage LLC · Spring City, UTS/N 46441 N6341FChronister Rex · Fort Smith, ARBuilt 1975 · S/N 18264166 N6341GKlapstein David L · Burlington, WIBuilt 1970 · S/N 15071841 N6341JAbriam Darryl Mods B · Jacksonville, FLBuilt 1980 · S/N 17273865 N6341KRiggin Flight Service Inc · Madison, SDBuilt 1975 · S/N 15077654 N6341PShumberger Ryan M · Carlisle, PABuilt 1981 · S/N 15285004 N6341SPradels Karis J · Murrieta, CAS/N R18201662 N63420Compton John · Jennings, LABuilt 1975 · S/N 15077301 N63423Hecht Jeffery W · Vassar, MIBuilt 1975 · S/N 15077304 N63424Luxaire Center Inc · Deland, FLBuilt 1975 · S/N 15077305 N63427Molitor John P · Hatfield, MABuilt 1975 · S/N 15077306 N6342DCourtney Walter William · Cameron Park, CABuilt 1979 · S/N 17272728 N6342FNetherton Ricky D · Blair, OKBuilt 1966 · S/N 337-0342 N6342LHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1980 · S/N 15284387 N6342YFdxp Inc · High Point, NCS/N 21064342 N63430Marr Brandon J · Monmouth, ORS/N 18052845 N63436Martino Aviation Inc · Rincon, GABuilt 1975 · S/N 15077312

Back to AD 87-20-03 R2