AD 2000-02-30
Registered aircraft · 270
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-02-30')
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-02-30')
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-02-30') 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-02-30') 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.
N52JWJ W Aviation LLC · Dover, DEFirst renewal noticeN52PYJk Aviation LLC · Carson City, NVN53GEWings & Rotors LLC · Wilmington, DEN555VEPrincess Aviation LLC · Fowler, CAN559CGOrtiz Luis Emerito Nieves · Ciudad De PanamaNon-citizen corporation, flight hours not reportedN55WJCo Fire Aviation Leasing Inc · Fort Morgan, CON561KEMaglaughlin Ronald D · Udall, KSFirst renewal noticeN57112Courtney Aviation LLC · Columbia, CAN572TNShelton Paul K · Flushing, NYN57RSKolob Canyons Air Services Inc · Wilmington, DEN57TBInternational Air Services Inc Trustee · Carson City, NVN580ERBlue Ocean Aerospace LLC · Fort Collins, CON586DVFlying A Flight Service LLC · Safford, AZN5878KClearwater Airco LLC · Anchorage, AKN58GSzarek Evelyn Personal Representative · Fairbanks, AKN5926KGulfstream Aerospace Corp · Savannah, GAN5955KVolare Via LLC · Piqua, OHN5956KSullivan Leo · Ofallon, ILN5REPennsylvania College Of Technology · Williamsport, PAN600PSPlane Services LLC · Twin Falls, IDN601WTNickel Family LLC · Bakersfield, CAN60BMValiair Lc Trustee · Casper, WYN615DPRay Aircraft Leasing LLC · Tuscaloosa, ALN6217DSmithey Larry M · Wake Forest, NCN6222DRobertson C A · Phoenix, AZN6253XMoudy James D · Fairhope, ALN6272XPrairie Aviation Museum Inc · Bloomington, ILN6278DSale Reported · Oklahoma City, OKSale reportedN630TAN630ta Corp · Miami, FLN6350UWeatherbird Ltd · New York, NYRegistration revokedN63DUCts Aviation Inc · Galesburg, MIN64PSSchiff Peter · Cookeville, TNN6517VDesert Flyers LLC · Calexico, CAN6540VPortland Community College · Portland, ORN66GWKolob Canyons Air Services Inc · Wilmington, DEN674NMMartin Nicolas · Rolling Hills, CAN677JRRoach James M · West Bountiful, UTN67CG1 Blue Sky LLC · Miami, FLN67WGAircraft Guaranty Corp Trustee · Oklahoma City, OKN680FTTwin Aviation LLC · Natchitoches, LAN680PLDw Educational Research Inc · Fowler, CAN680RRNizex Inc · Jackson, GAN68113Gogoplex LLC · Wilmington, DEFirst renewal noticeN6819QWalker Gilbert R · Brentwood, TNN681SPD&K Harvesting Inc · Labelle, FLN681TCRockstar Air LLC · Waco, TXN685LDPhoenixarrowcommander LLC · Key West, FLN6883SWebb Ronald G · Dickson, TNN690AGCay Air LLC · Wilmington, DEN690ARPonderosa Aviation LLC · Safford, AZ
Back to AD 2000-02-30