Skip to content

Registered aircraft · 54,017

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.

N52409Cosner Dirk · Greeley, COBuilt 1973 · S/N 18262587 N5240DBailey Carlton D Jr · Huntington, WVBuilt 1957 · S/N 50138 N5240EWilson Brent A · Carmel, INBuilt 1978 · S/N 17271791 N5240QRamesh Manohari D · Liberty Township, OHBuilt 1972 · S/N 15073140 N5240RRico Aviation Services Inc · Miami, FLBuilt 1974 · S/N 17263454 N52415Pryor Stanley C · Indianapolis, INBuilt 1973 · S/N 18262591 N52416Toepfer Stan L · Lanark, ILS/N 18262592 N52417Eaton Roger C DBA · Vernon, NYBuilt 1980 · S/N 17274511 N5241DSorbi Aviation Inc · El Cajon, CABuilt 1979 · S/N 17272465 N5241EBaldeo Kessho I · Bay Shore, NYBuilt 1978 · S/N 17271792 N5241FUnited States Air Force Owner · Apo, APBuilt 1965 · S/N 17253322 N5241JDuffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1980 · S/N 17273743 N5241PAtwater John G · Vero Beach, FLS/N 15284899 N5241QWings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 15285088 N5241TWeiss Gregory K · Colorado Springs, COBuilt 1981 · S/N R18201840 N52420Isaacs John S · Fruitland Park, FLBuilt 1973 · S/N 18262596 N52422Stevens Michael C · Kaysville, UTBuilt 1973 · S/N 18262597 N52426Smtm Holdings Inc · Wilmington, DEBuilt 1980 · S/N 17274515 N5242DR&R Aero Services LLC · Eden Prairie, MNBuilt 1979 · S/N 17272466 N5242EWeeks Charles C · Setauket, NYBuilt 1959 · S/N 50542 N5242QShimata Kenneth S · Honolulu, HIBuilt 1972 · S/N 15073142 N5242RProctor Daniel L · Elkton, VABuilt 1974 · S/N 17263456 N52430Beaudikofer Eric · El Centro, CABuilt 1973 · S/N 18262602 N52431Lippian James Michael · New Boston, TXBuilt 1973 · S/N 18262603 N52432Aftcloud Inc · Ontario, CABuilt 1980 · S/N 17274517 N52436Angel Aviation Inc · Peoria, AZBuilt 1980 · S/N 17274520 N52438Rick Aviation Inc · Newport News, VABuilt 1980 · S/N 17274522 N5243DStoltzfus Sandra · Kidron, OHBuilt 1957 · S/N 50141 N5243ECalifornia Professional Flyers Inc · Murrieta, CABuilt 1978 · S/N 17271793 N5243QCas Ltd · Swanton, VTRegistration expired, pending cancellationBuilt 1981 · S/N 15285089 N5243RDraco Flight School Inc · Chino, CABuilt 1974 · S/N 17263457 N52440Hap'S Air Inc · Ames, IABuilt 1981 · S/N 17274523 N52441Christiansen Aviation LLC · Wilmington, DEBuilt 1980 · S/N 17274524 N52443182-52443 LLC · Queen Creek, AZBuilt 1973 · S/N 18262612 N52447Msc Services Inc · Hugo, OKS/N 18262614 N52448Haman Peter A · Douglas, WYBuilt 1973 · S/N 18262615 N5244DMalnarick Kyce S · Anchorage, AKBuilt 1958 · S/N 50142 N5244EOpal Aviation LLC · Athens, GABuilt 1978 · S/N 17271794 N5244NCongressional Flying Club Inc · Gaithersburg, MDBuilt 1980 · S/N 18267594 N5244RClauson Ed P · Charlestown, RIBuilt 1974 · S/N 17263458 N5244URoberts Todd · Friday Harbor, WABuilt 1964 · S/N 206-0244 N5244VKnucklehead Aviation LLC · Cedar City, UTBuilt 1980 · S/N 172RG0481 N5244ZRobinson Levi B · Anchorage, AKBuilt 1981 · S/N U20606085 N52450Vandelay Investment Group LLC · Northbrook, ILBuilt 1973 · S/N 18262617 N52454Clemens Kayleen · Arnold, CABuilt 1973 · S/N 18262620 N52458Eightball Air LLC · Spokane, WAS/N 18262623 N52459Noonan Joseph E Jr · Northport, MEBuilt 1973 · S/N 18262624 N5245KPerun Av LLC · Cliffside Park, NJBuilt 1980 · S/N 17274029 N5245VMarianas Air Transfer Inc · Saipan, MPBuilt 1980 · S/N 172RG0482 N5245XPlane Fixer LLC · Ball Ground, GABuilt 1968 · S/N 18258856

Back to AD 87-20-03 R2