Skip to content

Registered aircraft · 442

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:80-22-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-22-13') 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:80-22-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-22-13')
  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:80-22-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-22-13')
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.

N2408BCrawford Richard D · Melbourne, ARBuilt 1978 · S/N 38-79A0048 N2408LAnywhere Atp LLC · Mount Juliet, TNBuilt 1979 · S/N 38-79A0696 N240FFreas Joseph R · Simi Valley, CABuilt 1981 · S/N 38-81A0081 N24101Babula Edward S · Harwood Heights, ILBuilt 1979 · S/N 38-79A1083 N2410TRozier Brett Arthur · Gainesville, GABuilt 1978 · S/N 38-78A0795 N2412LRobbins Warren N · Chandler, AZBuilt 1979 · S/N 38-79A0697 N24133Phelps Charles R · Princeton, KYBuilt 1979 · S/N 38-79A1089 N2414ASnapflightusa Inc · Port Matilda, PABuilt 1978 · S/N 38-78A0674 N2416BSouth Texas Air Force LLC · Mission, TXS/N 38-79A0052 N2417GDel-Sky LLC · Dilliner, PABuilt 1979 · S/N 38-79A0523 N2418KSterba Edward J · Ocala, FLBuilt 1979 · S/N 38-79A0622 N2419TN2419t Inc · Okeechobee, FLBuilt 1978 · S/N 38-78A0799 N2422DMckenzie Sandy S · O Brien, FLBuilt 1978 · S/N 38-79A0306 N2422PGharazeddine Raja N · Kaplan, LABuilt 1979 · S/N 38-79A0990 N24241Kirby Casey J · Oakland, TNBuilt 1979 · S/N 38-79A1104 N2424DRegistered aircraftS/N 38-79A0307 N2426CSmith Joseph R · Lawrenceburg, INBuilt 1978 · S/N 38-79A0179 N2426FSilcox Charles H · Lakeland, FLBuilt 1979 · S/N 38-79A0435 N24270Lafont Jack Christopher · Memphis, TNS/N 38-79A1108 N2428FSmtm Holdings Inc · Wilmington, DEBuilt 1979 · S/N 38-79A0436 N2428KMirzayan Varoojan Y · Fresno, CABuilt 1979 · S/N 38-79A0626 N2429KHarris Leritha M · Santa Cruz, CABuilt 1979 · S/N 38-79A0627 N242EEOrlowski Micheal A · Gold Hill, NCBuilt 1978 · S/N 38-78A0494 N24319N5746u LLC · Dover, DEBuilt 1979 · S/N 38-79A1110 N2431CUrra Pedro M · Tampa, FLS/N 38-79A0182 N2431FPilot Craft Aviation LLC · Monterey, CABuilt 1979 · S/N 38-79A0437 N2433FJohnson Paul · Newnan, GABuilt 1979 · S/N 38-79A0438 N2433NFalcon Aerolab LLC · Colorado Springs, COBuilt 1979 · S/N 38-79A0840 N2438LHart Lewis W · Rexburg, IDBuilt 1979 · S/N 38-79A0703 N24397Bryant Margaret A · Tallahassee, FLBuilt 1979 · S/N 38-79A1114 N2440CHeaton Thomas Caleb · Princeton, KYS/N 38-79A0187 N2440TEngler William O · Filion, MIBuilt 1978 · S/N 38-78A0803 N2441AKnowles Warren R · Ocean City, NJBuilt 1978 · S/N 38-78A0691 N2441FLandgren Jon C · Stanwood, WAS/N 38-79A0443 N2442FZeien Robert A · Charlton, MAS/N 38-79A0444 N2443FAnywhere Atp LLC · Mt Juliet, TNBuilt 1979 · S/N 38-79A0445 N2445DN5511f LLC · Voorhees, NJBuilt 1978 · S/N 38-79A0319 N2445TBurwell Jacqueline D · Potwin, KSBuilt 1978 · S/N 38-78A0804 N2446KWichita Flight Training LLC · Wichita, KSS/N 38-79A0639 N2446NPilot'S Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1979 · S/N 38-79A0847 N24477Novotny Randy · New Castle, PABuilt 1979 · S/N 38-79A1125 N2447KDamschroder Rex A · Fremont, OHBuilt 1979 · S/N 38-79A0640 N2448KCentral Valley Flight School LLC · Hanford, CABuilt 1979 · S/N 38-79A0641 N2450CCartwright Edward N · Winterville, NCBuilt 1978 · S/N 38-79A0191 N2450NBarton John S III · Gallatin, MOBuilt 1979 · S/N 38-79A0848 N2452GFlymax Aero LLC Trustee · Dover, DEBuilt 1979 · S/N 38-79A0530 N2452TAnywhere Atp LLC · Mt Juliet, TNBuilt 1978 · S/N 38-78A0807 N24540Nelson Scott W · Owasso, OKS/N 38-79A1129 N2456DRegistered aircraftBuilt 1978 · S/N 38-79A0321 N2456NCihak Anton W II · Goode, VABuilt 1979 · S/N 38-79A0849

Back to AD 80-22-13