Skip to content

Registered aircraft · 22,413

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N357MTJ & F Aviation Adventure LLC · North Fort Myers, FLS/N 28-21389 N357PPaphos Airways LLC · Farmingdale, NYBuilt 1977 · S/N 28-7816005 N3580KKline Justin L · Hudson, INBuilt 1967 · S/N 28-23638 N3581KVick Michael S · Camden, ALBuilt 1967 · S/N 28-23639 N3581WCloud Richard D · Lafayette, LABuilt 1966 · S/N 32-474 N3582KPine Point Aviation LLC · Sartell, MNBuilt 1967 · S/N 28-23641 N3584KWilliamson Conner James · Hernando, FLBuilt 1967 · S/N 28-23643 N3584WSeek Stephen E · Valles Mines, MOS/N 32-478 N3585MHanlin Dale E · Porter, TXBuilt 1978 · S/N 28R-7837126 N3585WRodriquez Nat III · Odessa, TXBuilt 1966 · S/N 32-479 N3587MWellspring Air Group LLC · East Helena, MTBuilt 1978 · S/N 28R-7803179 N3588MCavu Aviation LLC · Draper, UTBuilt 1978 · S/N 28R-7803180 N3589KClark Joseph D · Kilgore, TXBuilt 1967 · S/N 28-23646 N3589MGregory Kenneth C · Gilbert, AZBuilt 1978 · S/N 28R-7803181 N3589WCfi Aero LLC · Riverside, CABuilt 1966 · S/N 32-484 N358BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2024 · S/N 2881806 N358BTRorabaugh Kenneth P · Sunrise, FLS/N 32-40051 N358CAFreeman Braxton L · West Lebanon, NHBuilt 1989 · S/N 2841283 N358GAtp Taa LLC · Wilmington, DEBuilt 2020 · S/N 2881428 N358MKNorth Star Aviation · Mankato, MNBuilt 2022 · S/N 2881524 N358TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881858 N3590WAgoston Thomas M Trustee · Liberty Twp, OHBuilt 1966 · S/N 32-485 N3591RAwmr LLC · Conroe, TXBuilt 1970 · S/N 28-5704 N3592KBeckler Benjamin C · Middle Granville, NYBuilt 1967 · S/N 28-23647 N3592RBurnt Ridge LLC · Kalispell, MTBuilt 1969 · S/N 28-5705 N3592WFoothills Aviation Inc · Pickens, SCBuilt 1966 · S/N 32-488 N3593WGriffin Julie A · Locust Grove, GABuilt 1966 · S/N 32-489 N3594JWxs Flying LLC · Mesa, AZS/N 32-7840095 N3595WStanley Shawn G · Lorton, VABuilt 1966 · S/N 32-491 N3596KStall Breakers LLC · Sachse, TXBuilt 1967 · S/N 28-23648 N3596WAbdelqader Hamza Faris · Beaufort, SCBuilt 1966 · S/N 32-492 N3597KQuinn Knives LLC · Julian, CABuilt 1967 · S/N 28-23649 N3598WSwiss Eagles Inc · Las Vegas, NVBuilt 1966 · S/N 32-495 N359BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2024 · S/N 2881807 N359CHN2092r LLC · Irvington, VABuilt 1979 · S/N 32R-7985082 N359FAStratus Rr LLC · New Castle, DEBuilt 2022 · S/N 28020059 N359NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 2881658 N35AMJoseph Thomas C · Raleigh, NCS/N 28-5490 N35ATLoomis Matthew · Oshkosh, NEBuilt 1973 · S/N 28-7305530 N35CWTimoney James M · Auburn, MEBuilt 1979 · S/N 32-7940170 N35PABorzoya Aero Group Inc · Slatington, PABuilt 1977 · S/N 28-7716087 N35WCHawley Flying Club Inc · Fargo, NDBuilt 1979 · S/N 28-8016180 N3600RArapahoe Flight Club LLC · Colorado Springs, COBuilt 1969 · S/N 28-5706 N3601WPrecision Landings Inc · Wilmington, DEBuilt 1966 · S/N 32-498 N36024Walla Walla University · College Place, WABuilt 1978 · S/N 28R-7837262 N3602KHoulton International Flying Club · Houlton, MEBuilt 1967 · S/N 28-23651 N3602WJeswald Joseph M · Buffalo, NYBuilt 1966 · S/N 32-500 N3604KQureini Khalil H · Strongsville, OHBuilt 1967 · S/N 28-23652 N36052Icarus Flying Academy LLC · Farmingdale, NYBuilt 1978 · S/N 28-7816608 N36056Cleared Aviation LLC · Novato, CABuilt 1978 · S/N 28-7816609

Back to AD 87-08-08 R3