AD 98-01-01
Registered aircraft · 1,289
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-01-01')
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-01-01')
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-01-01') 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-01-01') 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.
N172JPWnc Aviation LLC · Arden, NCN172KKIasco Flight Training Inc · Redding, CAN172LKPinnacle Aviation Services Inc · Encinitas, CAN172RCWings Over Texas Holdings LLC · Denton, TXN172SJCommonwealth Of Massachusetts · Bridgewater, MAN172TQAvolant Aviation LLC · Mooresville, NCN172WGWings Over Texas Holdings LLC · Denton, TXN172WYCrosshares Aircraft Holdings LLC · Plymouth, INN1737STms Aviation Inc · Wilmington, DEN1747LCoco Aircraft Inc · Merritt Island, FLN174GFMarcus Air LLC · Plano, TXN178AFSoutheast Aircraft Leasing LLC · Jacksonville, FLN181MWCsa Aircraft Leasing LLC · Salt Lake City, UTN1823CA&E Flying Club Of Los Angeles · Hawthorne, CAN1828MCampbell Larry Lance · White Lake, MIN182ABFoyhwg Inc · Holbrook, NYN182AMScavella George A Jr · Hauppauge, NYN182CKDowning Richard C · Arlington, TXN182DDGulf Coast Helicopters Inc · Pearland, TXN182EERegistered aircraftN182ELElmore Donald B · Orange Beach, ALN182FNSumner Investments LLC · Denham Springs, LAN182GFGormley Lane Martin · Stanwood, WAN182GHTroy-Oakland Pilots Flying Club Inc · Troy, MIN182JDRegistered aircraftN182JSJohn W Spurlock Md Ltd · Bethlehem, PAN182KGKeefe Patrick M · Watersmeet, MIN182KHDowning Billy G · Imboden, ARN182LUTvpx Aircraft Solutions Inc Owner Trustee · North Salt Lake, UTN182PJHarris William · Bullard, TXN182SVSky-Vu Flyers Inc · Fishers, INN182TAJeppesen Employees Flying Assiciation Inc · Englewood, CON182TRSalley George M · Advance, NCN182VBNemirsky Nicholas · Huntington Beach, CAN182VPJobsight Delta Inc · Sugar Grove, ILN182WGBurgett Dale · Lake Lure, NCN182WMZjt Aviation LLC · Vidalia, GAN182XSCamp Chris M · Marshallville, OHN182YYForrest C Cranfill Construction Co · Shallotte, NCN182YZSouthern Latitude LLC · Alabaster, ALN184AFG & M Aircraft Inc · Wheat Ridge, CON184RDAfrican Parks Aviation Trustee · Cheyenne, WYN187DBSummerwind Aviation LLC · Mooresville, NCN18LWDirty Side Down Aviation LLC · Georgetown, TXN18PMNoel Michael Patrick · Poplar Grove, ILN191CACsa Aircraft Leasing LLC · Salt Lake City, UTN192YSanders Leonard S III · Electric City, WAN197BALewis University · Romeoville, ILN198BWFixed Wing Holding Co Inc · Pembroke Pines, FLN1998FSpartan Education Group LLC · Tulsa, OK
Back to AD 98-01-01