Skip to content

Registered aircraft · 17,028

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

N8916GSorenson Robert H · Forsyth, MTBuilt 1970 · S/N 18260456 N891SROmalley Benjamin P · River Falls, WIBuilt 1966 · S/N 17253588 N8920SWefald Richard I · Jordan, MNBuilt 1965 · S/N 15062220 N8923SHuang Chen · Chino Hills, CABuilt 1965 · S/N 15062223 N8926SRichardson Gordon P · Polson, MTBuilt 1965 · S/N 15062226 N8928SFaith Flight LLC · Hopkinsville, KYBuilt 1965 · S/N 15062228 N892HAInternational Air Services Inc Trustee · Carson City, NVS/N F150-0312 N8931GJordan Robert Nelson · Oakdale, LABuilt 1970 · S/N 18260471 N8933SHempy David B · Lexington, KYBuilt 1965 · S/N 15062233 N8934GCallender Andrew T · Howard City, MIS/N 18260474 N8935GHagouel Yehouda · Reseda, CABuilt 1970 · S/N 18260475 N8935SRegistration Pending · Mesa, AZRegistration pendingS/N 15062235 N8936SWings Over Texas Holdings LLC · Denton, TXBuilt 1965 · S/N 15062236 N8937GRussin William A · Gurnee, ILS/N 18260477 N8938GTenore William H · Lyons, COBuilt 1971 · S/N 18260478 N8938SBallou Skies Aviation Inc · Bucyrus, OHBuilt 1965 · S/N 15062238 N8939GIms Aviation LLC · Kawkawlin, MIBuilt 1970 · S/N 18260479 N894Blanton Aircraft Co Inc · Orlando, FLFirst renewal noticeBuilt 1968 · S/N 17257119 N8940GCapps Christopher N · Austin, TXBuilt 1970 · S/N 18260480 N8942GSale Reported · Stevensville, MTSale reported, canceledBuilt 1970 · S/N 18260482 N8943GTruyaert Ivan R Jr · New Carlisle, INBuilt 1970 · S/N 18260483 N8944GSagra Nw LLC · Ronan, MTBuilt 1970 · S/N 18260484 N8947SMatyas Aviation Inc · Sugarloaf, PABuilt 1965 · S/N 15062247 N8948GWilbur-Ellis Co · Salinas, CABuilt 1970 · S/N 18260488 N8949GChuckanut Flying Club Inc · Bellingham, WABuilt 1970 · S/N 18260489 N8951GThrash Helen · Pelahatchie, MSS/N 18260491 N8953GAirfleet Solutions LLC · Newark, DEBuilt 1970 · S/N 18260493 N8955SHewett Donnie · Little River, SCS/N 15062255 N8957SMiller Andy · Marana, AZBuilt 1965 · S/N 15062257 N8958SLeo Richard E · Malibu, CABuilt 1965 · S/N 15062258 N8961SJoham James R · Kurten, TXBuilt 1965 · S/N 15062261 N8963GThompson Cory D · Holly, COBuilt 1970 · S/N 18260503 N8964GSandige David J · Mckinleyville, CABuilt 1970 · S/N 18260504 N8965SKaufman Jayson R · Moundridge, KSBuilt 1965 · S/N 15062265 N8966GBerti Robert C · Diamond Springs, CABuilt 1970 · S/N 18260506 N8967GHill Cannon E · West Richland, WAFirst renewal noticeS/N 18260507 N8967SDemontgomery Peter J · Fyffe, ALBuilt 1965 · S/N 15062267 N8968NMowery Robert · Irvine, CABuilt 1970 · S/N A1500163 N8969GGaluska Matthew · Minnetonka, MNBuilt 1970 · S/N 18260509 N896SASwitlik Aviation Maintenance Inc · Fort Myers, FLBuilt 1970 · S/N 21059358 N8970SMiller Curtis D · Malabar, FLBuilt 1965 · S/N 15062270 N8971MDixon Gary Lynn II · Ooltewah, TNBuilt 1973 · S/N 177RG0371 N8972GDay & Night Plumbing & Heating LLC · Sidney, NEBuilt 1970 · S/N 18260512 N8973GGough John C · Gooding, IDFirst renewal noticeBuilt 1970 · S/N 18260513 N8974GPike Vincent I · Bagdad, AZBuilt 1970 · S/N 18260514 N8974SRegistration Pending · Bentonville, ARRegistration pendingS/N 15062274 N8976GTeeray LLC · Mountain City, TNBuilt 1970 · S/N 18260516 N8976SHattaway Laura C · Rossville, GABuilt 1965 · S/N 15062276 N8979SFurtadobradley D · Lodi, CAS/N 15062279 N8985SOrganization Of Black Aerospace Professionals · Westchester, ILBuilt 1965 · S/N 15062285

Back to AD 72-03-03 R3