AD 79-06-01
Registered aircraft · 140
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:79-06-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:79-06-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:79-06-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:79-06-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.
N69LARegistration Pending · Las Vegas, NVRegistration pendingN69VYAhlhorn Travis · New Braunfels, TXN6KJXta-Sea LLC · Gross Point Woods, MIN717HCLeading Edge Leasing LLC · Wilmington, DEN717HQArwen Evenstar LLC · Wilmington, DEN72GVHawkes Alexander · Mooresburg, TNN747CBAom Aircraft LLC · Wilmington, DEN75UTSkyward Solutions Inc · Lewes, DEN768ELRohrbaugh Mark II · Raymond, MEN7HPClausen Todd · Vancouver, WAN8000WMoore George D Jr · Waldo, FLN8001AFandler Frederick E · Denton, TXN80026Baldwin Philip · Spokane, WAN8002MJasper Aviation Inc · Jasper, ALN8003HShafer James H · Port Orchard, WAN8003QHocking Earl · La Salle, ILN80042Ippisch Steven B · Soldotna, AKN8004BInternational Air Services Inc Trustee · Carson City, NVN8004COrban Howard L · Rockford, MIN8004GAmazon Aero Corp · Wilmington, DEN8004RArbogast Matthew G · Ooltewah, TNN8005BAmphibians Plus LLC · Bartow, FLN8006EHot700 LLC · Boca Raton, FLN8009XFioravanti Barbara K · Mirror Lake, NHN8011XFly & Sea Inc · Pittsburgh, PAN80122Amphibians Plus LLC · Bartow, FLN8012ANiehaus James O · Erie, CON8012DWhitney Steven G · Glenview, ILN8014FRoebuck Craig M · Otter Creek, MEN820ANMazeika Aaron P · Dayt Bch Sh, FLN8543CMr B Aviation LLC · Sag Harbor, NYN8543HPorterfield Brian B · Wasilla, AKN8563YJohnson Richard · Fort Lauderdale, FLN8BZLongoria Carlos Federico · Austin, TXN91LMansberger Aircraft Inc · Fort Worth, TXN948PWEagles Soar LLC · Lewes, DEN956SLLittle James S · Douglass, TXN959DFAerologic LLC · Yorktown, VAN987SBYonge Lawrence W III · Summerfield, FLN98AKPonderosa Aircraft LLC · Great Falls, MT
Back to AD 79-06-01