Skip to content

Registered aircraft · 81,728

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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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.

N29520Best Equipment Leasing LLC · Bakersfield, CABuilt 1968 · S/N 17700940 N29521Harmon Brian L · Wichita, KSS/N 17700941 N29523Mcgaha Edgar E Jr · Rio Vista, CABuilt 1968 · S/N 17700942 N2952EDayton Michael R · Glen Allen, VABuilt 1978 · S/N 17271382 N2952MBrown Ben · Kasilof, AKBuilt 1946 · S/N 12-1347 N2952PTrue Carl B · Avalon, CABuilt 1955 · S/N 22-3224 N2952RTowers Roland M · Shady Shores, TXBuilt 1969 · S/N 28R-35344 N2952TWalters James F · Richton, MSBuilt 1967 · S/N 077 N2952YPreston Marty D · South Bend, INBuilt 1979 · S/N 28-7990580 N29530Rockdale Flying Tigers Inc · Rockdale, TXBuilt 1968 · S/N 17700944 N29531Pell George D · Hillsboro, ORBuilt 1968 · S/N 17700945 N29535Clouse Tyler Woods · Forest City, IABuilt 1979 · S/N 28-7990448 N29537Garcia John C · Peoria, AZBuilt 1979 · S/N 28-7990449 N2953829538 Aviation LLC · Fernandina Beach, FLBuilt 1968 · S/N 17700949 N29539Hoosier Fliers LLC · Bloomington, INBuilt 1968 · S/N 17700950 N2953EJensen James A · Madison, WIBuilt 1978 · S/N 17271383 N2953GNolde Norman L · Fayetteville, GABuilt 1967 · S/N 586 N2953MFawcett Walter L Jr · Wolfeboro, NHBuilt 1946 · S/N 12-1348 N2953TZavalney Carl G · Pollocksville, NCBuilt 1967 · S/N 078 N2953UClarkson Fredrich A · Oro Valley, AZBuilt 1979 · S/N 28-7990582 N2953XJohnston Daryl T · Euless, TXBuilt 1967 · S/N 17700353 N2953ZEverette John H · Garner, NCBuilt 1959 · S/N 22-6926 N29548Novelli William L · Orangevale, CABuilt 1968 · S/N 17700956 N2954NLewman Daniel O Jr · Summit, MSBuilt 1979 · S/N 28-7990586 N2954QClark Ronald Joe · Scottsdale, AZBuilt 1979 · S/N 28R-7918234 N2954XWilson Katelyn · Parkville, MOBuilt 1967 · S/N 17700354 N2954ZBarkley Terry W · Lakeside, ORBuilt 1959 · S/N 22-6927 N29552Montgomery Skyhawk LLC · Bethesda, MDBuilt 1974 · S/N 17264118 N29554Eagle Sky Patrol · Deadwood, SDBuilt 1968 · S/N 17700960 N2955BBiller Scott · Urbandale, IABuilt 1979 · S/N 28-7911285 N2955MRls Rental Co DBA · Joplin, MOBuilt 1977 · S/N 28-7816326 N2955QAussieyank Air LLC · Reno, NVBuilt 1979 · S/N 28-7911265 N2955RSmith Billy V · Baton Rouge, LABuilt 1979 · S/N 28-7911266 N2955TFive Five Tango LLC · Rockford, ILBuilt 1979 · S/N 28-7911267 N29561St Onge Adam R · Sterling, AKBuilt 1988 · S/N 1069 N29563Brown Winn D Jr · Horn Lake, MSBuilt 1968 · S/N 17700966 N2956AHuebner Dennis Andrew · Morgan Hill, CABuilt 1979 · S/N 28-7911269 N2956BFlorida Coatings & Waterproofing LLC · Fort Pierce, FLS/N 28-7911270 N2956CFlying The Fields LLC · Algonquin, ILBuilt 1979 · S/N 28-7911271 N2956LZembower Christopher L · Cumberland, MDBuilt 1967 · S/N 670090 N2956PVann Dudley Carroll · Greenville, NCBuilt 1979 · S/N 28-7916583 N2956RFlightline LLC · Summerville, SCBuilt 1979 · S/N 28-7990588 N2956ZAm Flite Inc · Valley, NEBuilt 1978 · S/N 1245-78 N2957Marrero Edgardo · Enterprise, ALBuilt 1971 · S/N 402 N2957FRichardson John Daniel · Madisonville, LABuilt 1979 · S/N 28-7911273 N2957LJohnson Cullen L · Abernathy, TXS/N 670091 N2957MJacobson Larry · Commack, NYBuilt 1979 · S/N 28-7911274 N2957NBak John A · Lake Forest, CABuilt 1979 · S/N 32-7940228 N2957PArwine James L · Waxahachie, TXBuilt 1955 · S/N 22-3230 N2957RBantle Aviation LLC · Midlothian, VABuilt 1979 · S/N 32-7940229

Back to AD 81-18-04 R2