Skip to content

Registered aircraft · 4,242

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:89-24-01-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:89-24-01-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:89-24-01-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:89-24-01-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:89-24-01-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:89-24-01-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.

N8523QLifetime Adventures LLC · Bellevue, MIBuilt 1976 · S/N U20603379 N8526QKenworthy Winston C · Odessa, TXBuilt 1976 · S/N U20603382 N852SDauenhauer Manufacturing Inc · Ketchum, IDBuilt 1978 · S/N P21000081 N852TSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1975 · S/N 414-0804 N853KTKansas State University Salina · Salina, KSBuilt 1993 · S/N CE-1765 N8546QBlack Andrew J · Broomfield, COBuilt 1976 · S/N U20603402 N855HSanford Larry D · Edmond, OKBuilt 1982 · S/N 414A0855 N8576QThompson Robert Lee · Moore, OKBuilt 1976 · S/N U20603432 N8580QBald Eagle Aviation LLC · Oakley, UTBuilt 1976 · S/N U20603436 N858BBEchelon Group Inc · Boise, IDBuilt 1979 · S/N 21063277 N858MLLang Inc · Wilmington, DEBuilt 1980 · S/N TJ-257 N8598QTolley Samuel M · Rangely, COBuilt 1976 · S/N U20603453 N85AMLitchfield Lantz Dr · Las Vegas, NVBuilt 1973 · S/N 414-0435 N85MEGlobal Petroleum Services LLC · Greenville, SCBuilt 1978 · S/N TJ-168 N85PEMidwest Airmotive Inc · Mount Sterling, KYBuilt 1975 · S/N U20602774 N85PGN85pg LLC · Atlanta, GABuilt 1985 · S/N 46-8508066 N85RTJetprop Aviator LLC · Lewes, DEBuilt 1985 · S/N 8508033 N8605KWadsworth & Wadsworth LLC · Morehead City, NCS/N 340A1241 N8632KEano Air 340 LLC · Highland, UTBuilt 1981 · S/N 340A1243 N8636KM & J General Contractors Inc · Elgin, ILBuilt 1978 · S/N 340A0562 N8637KCommonwealth Capital Corp · Wilmington, DEBuilt 1978 · S/N 340A0604 N8647KJughead Aircraft LLC · Salina, KSBuilt 1978 · S/N 340A0605 N8647QTechnical Applications & Consulting LLC · Topeka, KSBuilt 1976 · S/N U20603463 N864CMForss Jamey L · Ferndale, WABuilt 1979 · S/N 340A0683 N864JBBas Part Sales LLC · Greeley, COBuilt 1986 · S/N 4608009 N8652KDelta Charlie Company LLC · Billings, MTS/N 340A0606 N866RAircraft Partner Holdings Inc Trustee · BerlinBuilt 1980 · S/N EA-105 N8671KFlight Unlimited LLC · Dover, DEBuilt 1978 · S/N 340A0611 N8675KJjjp North LLC · New London, NCBuilt 1978 · S/N 340A0614 N86AWMohave County Sheriff'S Office · Kingman, AZBuilt 1978 · S/N 414A0040 N86DHHolloway'S Tire And Auto Service Inc · Thomaston, GABuilt 1984 · S/N 21064832 N86MTWhite Knuckles Aviation LLC · Carson City, NVBuilt 1980 · S/N P21000533 N86PDTanric Aviation LLC · Tuscola, TXBuilt 1982 · S/N 414A0837 N86VSPlotkin Aviation LLC · Boca Raton, FLS/N 414-0955 N8702KSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 340A0623 N8707KDelaware Corp · Topping, VAS/N 340A0982 N870FSLindsey Norman A · Richardson, TXBuilt 1987 · S/N 4608051 N870VLCaribbean Flyers LLC · San Juan, PRBuilt 1981 · S/N 402C0616 N8711KGraham Thomas R · Bonita Springs, FLS/N 340A0627 N8712KKirkmeyer Thomas · Kimberly, IDBuilt 1978 · S/N 340A0628 N871VLZee Enterprise Inc · Chicago, ILBuilt 1980 · S/N 402C0290 N8720KZielinski John P · Queen Creek, AZBuilt 1978 · S/N 340A0631 N87221Chester Darren Dw · Sioux Falls, SDS/N 310R0306 N8725QN8725q LLC · Grand Junction, COBuilt 1976 · S/N U20603478 N8727387273 LLC · Reno, NVBuilt 1975 · S/N 310R0330 N8727KFrosty Acres LLC · Hailey, IDS/N 340A0633 N87293Dinaland Aviation · Vernal, UTS/N 310R0505 N87356Kovacs Endre · Plant City, FLBuilt 1975 · S/N 310R0527 N87393310 Amigos LLC · Stuart, FLS/N 310R0542 N87443Keystone Aerial Surveys Inc · Philadelphia, PABuilt 1976 · S/N 310R0562

Back to AD 89-24-01 R1