AD 98-05-14 R1
Registered aircraft · 909
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-05-14-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-05-14-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-05-14-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-05-14-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.
N6229CClause James W Trustee · La Quinta, CAN6237YStrategic Sourcing Solutions Inc · Topeka, KSN6239YBlue Horizon Aviation LLC · New Concord, OHN6262KBrz Air LLC · Beaumont, TXN6267YZero Four Twelve LLC · Clovis, NMN6274AA V T210 LLC · Palmdale, CAN6278YTown & Country Aviation LLC · Sunnyvale, CAN627BTAviation Global Inc · Saint Augustine, FLN6280PAirborne Equipment Inc · Hendrum, MNN628TTTollen Troy J · Austin, TXN6290WLord Of The Wings LLC · Syracuse, NYN6291CSatl Ranch Aviation LLC · Midland, TXN6294PMarkowich Darren K · Gilbert, AZN6295YSkydoc LLC · Mokena, ILN6297YL&L Aviation LLC · Baden, PAN6299CCenturion Flight LLC · Auburn, WAN6299PDanlars Aircraft Sales · Mccall, IDN62SK55x LLC · Kalispell, MTN6300PSchrempp Aviation LLC · Winnemucca, NVN6306CLongs Air Conditioning Inc · Avon Park, FLN6314CC4p LLC · Jackson, TNFirst renewal noticeN6320PSims Jacob Trustee · Montrose, CON6328CArnold Aviation & Thunder Mountain Express Inc · Cascade, IDN6328PSabath Kenneth J Trustee · Powell, WYN6328YKoehn Lacey · Van Horn, TXN6329YDiablo Aviation LLC · Pleasanton, CAN6339CBowles Donald E Jr · Dallas, TXN6344YCole William G · Garner, NCN6355CDutch Air LLC · Kalispell, MTN6359WScarlett Cameron O · Madison, WIN6362AMillican Clifford A · Burleson, TXN6364CSukhakarta Rentals LLC · Cedar Park, TXN6385PBada Alfredo · Mcallen, TXN6386CBas Part Sales LLC · Greeley, CON6388YMaclean Kenneth J · Northborough, MAN6389WSpenco Inc · Sale Creek, TNN6392CTretter Nicholas · Holden, MAN6397YAsher James A · Pasadena, CAN6398WPivac Jorge I · Chandler, AZN6398YSinglepoint Technologies Corp · Richmond, VAN6399KI B Development LLC · Monahans, TXN639FSC&Bh LLC · Vernal, UTN6402NManos Con Alas Aviation · Stateline, NVN6408NBorders Nowell W · Edinburg, TXN6409WBreedlove Joe · Skiatook, OKN6409YChino Aviation Inc · Chino, CAN6410NAerial Services Inc · Cedar Falls, IAN6413PAlta Air LLC · Boise, IDN6416WGallien Anthony · Livermore, CAN6417NTaylor Michael Norman · Chino Hills, CA
Back to AD 98-05-14 R1