AD 2000-25-02 R1
Registered aircraft · 7,563
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-25-02-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:2000-25-02-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:2000-25-02-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:2000-25-02-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.
N84113Palmatier Robert J · Orange Park, FLN84115Stormer Isaac · Curtis, WAN84116Koliadko Joseph I · Luray, VAN84120Saylor Kasey · Searcy, ARN84121Myers Stanley A · Linn, MON84123Cahill Herbert G · Chesapeake, VAN84124Mussman Craig · Grant Park, ILN84126Three J Flying LLC · West Des Moines, IAN84127Anderson Blake T · Locust Grove, GAN84139Bakrevski Lupcho · Valparaiso, INN84144Grindeland Ethan P · Hatton, NDN84149Bower Kevin R · Oldenburg, INN84155Grissom Michael D Jr · Henderson, NCN84157Padisak Michael · Traverse City, MIN84158Rinaudo James J · Gulf Shores, ALN84160Preston Robert J · Pittstown, NJN8416388 Charlies Inc · Palmyra, WIN84164Eisberg Keith W · Columbia, MON84166Prather Carl Lynn · Gilroy, CAN84167Tate Edwin N · Sheridan, ORN84168Bost Roger C · Greensboro, NCN84171Gates Glen C · Lapeer, MIN84177Zimmerman Steven W · Olathe, KSN84178Thompson Steve DBA · Pauls Valley, OKN84181Purcell David S · Chandler, AZN84184Waterman David N DBA · Amery, WIN84192Burraston Richard D · Millcreek, UTN84197Short Michael J · Independence, ORN84198Jack Jeremiah Russell · Napa, CAN84199Owen James G · Maynardville, TNN84203Harter Michael R · Greenfield, INN84206Sale Reported · West Richland, WASale reportedN84215Hardy Randall B · Argyle, TXN84218Feeney Francis Kevin · Spencer, NYN84222Ornelaz Bernice R · San Jose, CAN84228Marshall Donald R · Cape Girardeau, MON84230Yuri Flyers LLC · Kalamazoo, MIN84231Ptaschinski Charles O · Shawano, WIN84232Koehler Steven W · New Braunfels, TXN84238Simmons Rita B · Saint George, MEN84241Kuhn Darrell G · Irma, WIN84242Steck Paul D · Pelham, NHN84244Campbell Stephen C · Millinocket, MEN84246Light Flight Balloons Inc · Bel Air, MDN84252Calk Mark C · Troy, ALN84254Middleton Steven H · Monroe, NCN84255Black James W · Kenly, NCN84261Holcomb Garry M · Point, TXN84268Zvada Stephen P · Wadsworth, OHN84269Super Cub Flyers Inc · Tower, MN
Back to AD 2000-25-02 R1