Registered aircraft · 10,537

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:2004-25-16-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:2004-25-16-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:2004-25-16-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:2004-25-16-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:2004-25-16-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:2004-25-16-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.

N4462PHighlands Aero Flight Center LLC · Abingdon, VABuilt 1962 · S/N 23-1983 N4462SMaxxum Financial Group Inc · Destrehan, LABuilt 1975 · S/N TC-1876 N446BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2023 · S/N 4496553 N446BLBlue Line Aviation LLC · Smithfield, NCBuilt 2025 · S/N 4496600 N446DWAnnes Wings LLC · Boulder, COBuilt 1978 · S/N 34-7870051 N446MKNorth Star Aviation · Mankato, MNBuilt 2018 · S/N 4496448 N446PAHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2001 · S/N 4496086 N446SNWarren Dennis · Las Vegas, NVBuilt 1966 · S/N 337-0454 N4473PSemeniuk Steven T · Houston, TXS/N 23-2018 N4474WR And S Aviation LLC · Corning, ARBuilt 1974 · S/N TH-431 N4475PRamaswamy Gautam · Clearwater, FLBuilt 1961 · S/N 23-1997 N4475TWings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250106 N4476WBmg Aviation Leasing LLC · Bloomington, INBuilt 1974 · S/N TC-1809 N4479FDurosinmi Lateef · North Las Vegas, NVS/N 34-7670338 N447BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2024 · S/N 4496581 N447BLBlue Line Aviation LLC · Smithfield, NCBuilt 2025 · S/N 4496606 N447MKNorth Star Aviation Inc · Mankato, MNBuilt 2019 · S/N 4496459 N447TThompson Systems Inc · Amana, IABuilt 1969 · S/N 27-4288 N4481SAc Aviation LLC · Searcy, ARBuilt 1975 · S/N TC-1881 N4481TValdes Eusebio · Miami, FLS/N 34-7250108 N4482WWheels In The Well LLC · Jonesboro, ARBuilt 2000 · S/N TH-1964 N4487PAccelerated Aviation Instruction LLC · Owatonna, MNBuilt 1962 · S/N 23-2009 N448BLBlue Line Aviation LLC · Smithfield, NCBuilt 2025 · S/N 4496607 N448JAGood Flight Aviation LLC · Stockton, CABuilt 1996 · S/N 4496011 N448JGPritzker Stephen L · Scottsdale, AZFirst renewal noticeS/N 34-7770379 N448MKNorth Star Aviation · Mankato, MNBuilt 2021 · S/N 4496518 N448SPWilliams Donald B · Sharps Chapel, TNBuilt 1964 · S/N TC-768 N4490PWelke Aviation Inc · St James, MIBuilt 1962 · S/N 23-2012 N4490WFrisch Josef C · Belmont, CABuilt 1974 · S/N TC-1683 N4492JJohnson Richard E · Waynesboro, MSBuilt 1980 · S/N TH-1199 N4492UAircraft & Aviation Professionals LLC · Coldwater, MIS/N 421C0020 N44945Valiair Lc Trustee · Casper, WYBuilt 1977 · S/N 34-7770378 N4494FBella'S Business LLC · Kalispell, MTBuilt 1959 · S/N 23-1815 N4494PSimon Mitchell B · Edison, NJBuilt 1961 · S/N 23-2016 N44968Mil2atp Inc · Pikeville, NCBuilt 1977 · S/N 34-7770380 N4496PPerez Amaro Angel L · Arecibo, PRBuilt 1960 · S/N 232011 N4497PMatthews Aviation LLC · Hardinsburg, KYBuilt 1961 · S/N 23-2020 N4499PTls Aviation · Marysville, WABuilt 1961 · S/N 23-2022 N449BLBlue Line Aviation LLC · Smithfield, NCBuilt 2025 · S/N 4496608 N449MKNorth Star Aviation · Mankato, MNBuilt 2022 · S/N 4496534 N449PAChristiansen Aviation LLC · Wilmington, DEBuilt 2004 · S/N 4496185 N449TAValiair Limited Company Trustee · Casper, WYS/N 31-480 N44ACFox Aircraft LLC · Bethel, AKBuilt 1980 · S/N 31-8052147 N44AEMiloud Chadd K · Fort Worth, TXBuilt 1978 · S/N 347870240 N44CYMiskell Christopher S · Senoia, GABuilt 1973 · S/N TC-1629 N44FDHildreth David M · Kennesaw, GABuilt 1956 · S/N 23-500 N44GAFly Qts LLC · Oconomowoc, WIBuilt 1978 · S/N 414A0036 N44GRFlying High LLC · Plainfield, ILBuilt 1976 · S/N 31-7652074 N44KFEbert Construction Co Inc · Wamego, KSBuilt 1974 · S/N 421B0598 N44LBCadet Michel · Locust Grove, GABuilt 1966 · S/N 337-0561

Back to AD 2004-25-16 R1