Skip to content

Registered aircraft · 454

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

N11FULow Country Soaring Association · Ridgeland, SCS/N 25-7556221 N122KYSeminole Flying & Soaring Inc · Clermont, FLBuilt 1968 · S/N 25-4576 N131ABPlane And Simple Leasing LLC · Delano, MNBuilt 1965 · S/N 25-3693 N138ABAerial Banners Inc · Pembroke Pines, FLBuilt 1966 · S/N 25-3915 N145ABAerial Banners Inc · Pembroke Pines, FLBuilt 1965 · S/N 25-3137 N150PPBurghduff Aviation LLC · Ludlow, SDS/N 25-23 N169ABSouthern Cub And Aircraft Restoration LLC · Pensacola, FLBuilt 1968 · S/N 25-4517 N189ABAerial Banners Inc · Pembroke Pines, FLBuilt 1964 · S/N 25-2781 N225ABMinden Soaring Club Inc · Minden, NVBuilt 1967 · S/N 25-4236 N235WERudloff Uwe K · Lake Village, INBuilt 1975 · S/N 25-7556108 N2360QStar Ads Incorporated · Torrance, CABuilt 1979 · S/N 25-7956034 N2399UChilhowee Soaring Association Inc · Benton, TNBuilt 1972 · S/N 25-5429 N243CGTampa Bay Soaring Society · Zephyrhills, FLBuilt 1972 · S/N 25-5450 N244CGEagle Sport Aviation Club Inc · De Leon Springs, FLBuilt 1968 · S/N 25-4734 N250BASouthern Cub & Aircraft Restoration LLC · Pensacola, FLBuilt 1971 · S/N 25-5425 N2583QDykstra Tony R · Pipestone, MNS/N 25-8056049 N3085YMarsh Aviation Of Marana Inc · Marana, AZS/N 25-4265 N312MMBadgley Robert W · Stanley, NDBuilt 1976 · S/N 25-7656085 N337ABPlane And Simple Leasing LLC · Delano, MNBuilt 1960 · S/N 25-459 N35FASt Louis Soaring Association · Saint Louis, MOBuilt 1964 · S/N 253291 N37ABPlane And Simple Leasing LLC · Delano, MNBuilt 1960 · S/N 25-340 N386ABPlane And Simple Leasing LLC · Delano, MNBuilt 1966 · S/N 25-3790 N4114KNorth Florida Soaring Society Inc · Jacksonville, FLBuilt 1966 · S/N 25-4043 N4177EAerial Banners North Inc · Pembroke Pines, FLBuilt 1978 · S/N 25-7856059 N424BYSkyline Soaring Club Inc · Front Royal, VABuilt 1968 · S/N 25-4640 N430ABAerial Banners Inc · Pembroke Pines, FLBuilt 1966 · S/N 25-3996 N4331YOdonnell Daniel V · Dover, DEBuilt 1968 · S/N 25-4821 N4333YEvergreen Soaring Inc · Lynnwood, WABuilt 1968 · S/N 25-4824 N4335YTexas Soaring Association Inc · Midlothian, TXS/N 25-4827 N4337YJourneys Aviation Inc · Boulder, COBuilt 1968 · S/N 25-4830 N4362YBarrett Jane T · Tehachapi, CABuilt 1969 · S/N 25-4868 N4385YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N 25-4892 N4386YSoaring Club Of Houston · Waller, TXBuilt 1969 · S/N 25-4893 N4402YGoven Benjamin T · Turtle Lake, NDBuilt 1966 · S/N 25-4008 N4420YKingsley Kiman J · Miller, MOBuilt 1966 · S/N 25-4040 N4428PSilver Creek Glider Club · New Douglas, ILBuilt 1964 · S/N 25-2719 N4428YCherry Hill Aviation Inc · Freetown, INS/N 25-4053 N4429YBlackstone Aircraft LLC · Hartselle, ALS/N 25-4055 N4430YEvergreen Soaring Inc · Lynnwood, WABuilt 1966 · S/N 25-4056 N4440YMayes Brett R · Williams, CABuilt 1966 · S/N 25-4074 N4460YQuality Aviation Inc · Marana, AZBuilt 1966 · S/N 25-4109 N4461YRubbert Jan D · Upham, NDBuilt 1966 · S/N 25-4111 N4467YKingsley Kiman J · Miller, MOBuilt 1966 · S/N 25-4119 N4468YBegrow Adroaldo Dorivaldo · Gulf Shores, ALBuilt 1966 · S/N 25-4120 N4470YAmundson Daryl A · Blue Earth, MNBuilt 1966 · S/N 25-4124 N4472YSilent Flight LLC · Payette, IDBuilt 1966 · S/N 25-4128 N4477PAirknocker Inc · Wilmington, DEBuilt 1960 · S/N 25-253 N4479YKnutson Wayne R · Tioga, NDBuilt 1966 · S/N 25-4108 N4482YMiller Andy D · Marana, AZS/N 25-4140 N4484YMasterwings LLC · Princeton, KYBuilt 1966 · S/N 25-4144

Back to AD 2007-08-07