AD 2000-22-18
Registered aircraft · 914
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:2000-22-18')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-22-18')
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:2000-22-18') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-22-18') 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.
N416DMcginnis Aviation LLC · Kentwood, MIN416JSC Randy Landis Dds Inc · Oroville, CAN4178SGlad Aviation LLC · Gilford, NHN4188SMajor Air LLC · Charleston, SCN418RWPower Aero Inc · Scituate, RIN41ECTreeline Helicopters Inc · Bristol, TNN41LM92 Aviation LLC · Whiteville, NCN4203ABas Part Sales LLC · Greeley, CON423CLTmt Aero Inc · Perrysburg, OHN424QLj Sutter Aviation LLC · Shavertown, PAN426DDRare Air Aviation Services LLC · Santa Rosa, CAN4298YAir LLC · Fresno, CAN42FQSp Aviation Group LLC · Weston, FLN42KWMarine Aviation LLC · Lyme, NHN42TBFlores Nicholas L Jr · San Antonio, TXN430RTTortorigi Aviation LLC · Birmingham, ALN430RVVermejo Aviation LLC · Boulder, CON4324VTriple Aaa LLC · Garden City, KSN432DLWhitecotton William W · Eldersburg, MDN4331WRicca Gregory F Trustee · Bentonville, ARN436ATWheels Up LLC · Aloca, TNN4375WTouch N Go Aeroworks LLC · Greenville, SCN4380WAtaraxia Aircraft Holdings LLC · Greenville, SCN4394WSisson James M · Orlando, FLN43HPBarbara Aviation Inc · Middletown, DEN440BLL R Aviation LLC · Plymouth, NCN443PFrederick Investment Corp · Raleigh, NCN4449WJameson Clarke Enterprises LLC · Houston, TXN4474WR And S Aviation LLC · Corning, ARN4482WWheels In The Well LLC · Jonesboro, ARN4492JJohnson Richard E · Waynesboro, MSN450JRNowell Borders Lp · Edinburg, TXN450THHk Air LLC · Byron, GAN451SBModleski Matthew · Noblesville, INN4545MSimplifly Aviation LLC · Elon, NCN4547MOxly Aviation LLC · Wilmington, DEN457BBRlm Investment Holdings LLC · Wilmington, NCN457BKForty Sixty Two B Inc · Lubbock, TXN457DFUsda Forest Service Fepp · Mcclellan, CAN458DGIron Street Aviation LLC · North Kansas City, MON458GLIowa Great Lakes Flyers Inc · Cheyenne, WYN458KAugust Aero LLC · Kalispell, MTN458SSSos Ranch LLC · Humble, TXN4590SConner Chad E · Paris, TNN45EEVazarani Sarah · Concord, MAN45FMBurgner Vanessa C · Belleville, MIN45PTCleaver Anthony M · Boulder, CON4607MClark Jean F Trustee · North Falmouth, MAN4610WTen Right Aviation LLC · Abbeville, LAN4615SMurrer Aviation Inc · Canonsburg, PA
Back to AD 2000-22-18