Skip to content

Registered aircraft · 68,369

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.

N13504Brewer Ruthie C · Wendell, NCBuilt 1973 · S/N 17262801 N13506Asberry Gregg · Sidney, ARBuilt 1973 · S/N 17262803 N13507Torell Pamela O · Port St Lucie, FLBuilt 1973 · S/N 17262804 N13508Labrador Aviation LLC · Barboursville, VABuilt 1973 · S/N 17262805 N1350CBryant Stephen C · Anchorage, AKS/N 18-2513 N1350JFish Associates Inc Trustee · Wilmington, DEBuilt 1976 · S/N 516 N1350RBates Victoria Anna · West Union, WVS/N AA1B0650 N1350WMaxwell Don P · Longview, TXS/N 2631 N13511Meteor Aviation · Kirkland, WAFirst renewal noticeS/N 17702430 N13513Stella Luna Aviation LLC · Olive Branch, MSBuilt 1973 · S/N 17262810 N13515412 Jw Aviation LLC · Dover, DEBuilt 1976 · S/N 17702431 N1351CSapphire Vistas LLC · Iowa City, IAFirst renewal noticeBuilt 1977 · S/N 17702708 N1351EJ & S Air Ventures LLC · Eagle Lake, FLBuilt 1978 · S/N 17270965 N1351UThomas Jackson Smith · Baton Rouge, LAS/N 17267022 N1351WAllen Mark S · Reno, NVBuilt 1963 · S/N 2632 N13521Ekberg Jeff M · Emmett, IDS/N 17262817 N13522Recker Edward J · Surprise, AZBuilt 1973 · S/N 17262818 N13524Loomis Avaition LLC · Columbus, OHBuilt 1973 · S/N 17262820 N13526Rolla Aero Inc · Rolla, NDBuilt 1976 · S/N 17702433 N13527Beekman Gary J · Oconto, WIBuilt 1973 · S/N 17262823 N13529Meyer Ricky L · New Liberty, IABuilt 1973 · S/N 17262825 N1352CBaker Mark R · Summerland Key, FLBuilt 1953 · S/N 18-2515 N1352EMclv2020 LLC · Las Vegas, NVBuilt 1978 · S/N 17270966 N1352JBecker Norbert E · Lake Ozark, MOBuilt 1975 · S/N 352 N1352PHouse Travis · Bristow, VABuilt 1955 · S/N 23-401 N1352UN19630 LLC · Fort Collins, COBuilt 1976 · S/N 17267023 N13535Aviation Academy LLC · Wichita, KSS/N 17262830 N13537Sale Reported · Brownsville, ORSale reported, pending cancellationBuilt 1973 · S/N 17262832 N13539Pawul Frank A · Graham, WABuilt 1973 · S/N 17262833 N1353CMason Teresa J · Tucson, AZBuilt 1977 · S/N 17702709 N1353JBledsoe Robert · Orlando, FLBuilt 1975 · S/N 353 N1353NSubsonic Aviation Leasing LLC · Grandville, MIBuilt 1979 · S/N AA5B1242 N1353RRegistered aircraftBuilt 1979 · S/N WA-6 N1353UReynolds Darryl G · Wills Point, TXBuilt 1976 · S/N 17267024 N1353YRust Joyce A · Bourbon, INBuilt 1974 · S/N 28-7405152 N13540Spangler Taylor L · Andover, KSBuilt 1973 · S/N 17262834 N13541Lowcountry Flying Club · Moncks Corner, SCBuilt 1976 · S/N 17702434 N13543Skylink II LLC · Florissant, MOBuilt 1973 · S/N 17262836 N13544Registered aircraftBuilt 1973 · S/N 17262837 N13548Havana Flyers Assoc · Petersburg, ILBuilt 1973 · S/N 17262840 N13549Big Sky Communication & Cable Inc · Billings, MTBuilt 1973 · S/N 17262841 N1354CAklested William T · Palmer, AKS/N 18-2518 N1354TRiverside Flight Academy Inc · Riverside, CABuilt 1972 · S/N 28R-7235268 N1354UVosskuhler Darlene Duke · Sun City West, AZBuilt 1976 · S/N 17267025 N13551Eagle Sky Patrol Inc · Deadwood, SDBuilt 1973 · S/N 17262843 N13552Newton Property Leasing LLC · Greene, IABuilt 1973 · S/N 17262844 N13554Registered aircraftBuilt 1933 · S/N A-288 N13555Krueger Steven T · Leander, TXBuilt 1973 · S/N 17262846 N13559Bauta Carlos L · Bristol, INBuilt 1973 · S/N 17262848 N1355FChi Aerospace Inc · Portsmouth, NHBuilt 1979 · S/N 17272998

Back to AD 90-04-06 R1