AD 98-21-21 R1
Registered aircraft · 85,620
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
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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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.
N2333KAircraft Guaranty Corp Trustee · Oklahoma City, OKN2333RSightler Marshal · Taylors, SCN2333TNottingham Jeffrey A · Locust Grove, GAN2333VTytan Holdings LLC · Kalispell, MTN2333XHjr Aviation LLC · Reno, NVN2334CTallahassee Flying Club Inc · Tallahassee, FLN2334DCaruso Timothy E · Gainesville, VAN2334MSunrise Aviation Inc · Ormond Beach, FLN2334TGogoplex LLC · Wilmington, DEN2334USimplifly LLC · Mesa, AZN2334WBlazek James T · Malta, ILN23353Weems Widener E · San Antonio, TXN2335DWinch Cary F · Necedah, WIN2335EMindy Limited LLC · Muscatine, IAN2335FGravitte Peter F · Napa, CAN2335GRegistered aircraftN2335KBflyin LLC · Scottsdale, AZN2335RPropellerhead Aviation LLC · Santa Cruz, CAN2336GLogue Elmer S · Derby, KSN2336MHerd James L · Gardnerville, NVN2336RPerera Nandana L · Logan, OHN2336TN2336t Airplane Partnership LLC · Wilmington, DEN2336UWilson Milledge L · Prosperity, SCN2337DSurely You Cant Be An LLC · Albuquerque, NMN2337TPate Jason L · Bedford, TXN2337UOne Niner Right LLC · Berkeley, CAN2338FDonnell James C · Crowville, LAN2338GIberlin Ranch · Gillette, WYN2339CSullivan Nathan · Croton, OHN2339DWenrich Kevin P · Myerstown, PAN2339GWetzel William W · Carrizozo, NMN2339RStephens Grant A · Palmer, AKN2339TK E F Enterprises Inc · Plymouth, MAN2339VBradford Sarah Elisabeth · Norman, OKN2339XPetet David G · Orofino, IDN233AKRoettele Mark · Lake Havasu City, AZN233CNw Beech Boys LLC · Everson, WAN233CBZions Credit Corp · Salt Lake City, UTN233CKAllen Max · Jefferson, GAN233CTHoneycutt Danny · Angier, NCN233DKitley David Matthew · Dolores, CON233DFFleckenstein David · Nacogdoches, TXN233ESSpain Aviation LLC · Lynchburg, VAN233FCPulliam Dan · Baldwin City, KSN233GKGoodwin Joseph N · Grass Valley, CAN233GSGreenville County Sheriffs Office · Greenville, SCN233JBN233jb LLC · Bethesda, MDN233JRNorthstar Aerospray Inc · Clara City, MNN233LHLetts Jackson W · Kansas City, KSN233MGFly Safe LLC · Belle Isle, FL
Back to AD 98-21-21 R1