AD 66-30-07
Registered aircraft · 75
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:66-30-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:66-30-07')
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:66-30-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:66-30-07') 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.
N123MKSolomon Steven · Cherry Hill, NJN166SPSwitzer James DBA · Costa Mesa, CAN2782YDegroff Steven A · Berne, INN400CJDeepe Mark D · York, NEN400EDavis Richard · Reno, NVN400FKFinazzo Joseph · Fort Mohave, AZN400FW400fw LLC · Largo, FLN400GCNorthern Sky Aviation LLC · Harbor Springs, MIN400GUTriple S Aviation LLC · Wilmington, DEN400HLSale Reported · Lamesa, TXSale reportedN400HPMorgan David W · Canton, MIN400HRDavis Gary L · Burleson, TXN400KKDennehey Patrick N · Cameron Park, CAN400NQN400nq LLC · Gleeley, CON400PAN6105s LLC · Norwood, NCN400PPMig Aviation LLC · Sandy, UTN400SWDay Stephen F · Queen Creek, AZN400WGRegistered aircraftN400WLHammer Construction Corp · Miami, FLN400YKarschney Rich · Seattle, WAN63FSandella William A · Medfield, MAN64400Mascari M Richard · Iowa City, IAN702JDCrossbow Aviation LLC · Reno, NVN777MURobinson James G · Baltimore, MDN8400PPiper Aviation Museum Foundation Inc · Lock Haven, PAN8401PPrecision Design Inc · Weatherford, OKN8414PRudd Wayne · Basalt, CON8421PWills Terry W · Cedar Park, TXN8438PCrews Cobert J · Shady Shores, TXN8440PSpoor John B · Sandwich, ILN8448PBissell Lee · Culver, ORN8450PKroll Corey · Gilbert, SCN8452PMann Larry G · Lubbock, TXN8455PTcb Properties Ltd · Wilmington, DEN8456PBeckmann Gerhard David · Covington, LAN8458PSchoolcraft Carl L · West Harrison, INN8459PDiesel LLC · Concord, NCN8460PLadet William D · Las Vegas, NVN8465PHorton Charles S Jr · Diamondhead, MSN8466PBrindeiro Stephen M · Artesia, NMN8468PLucy Douglas S · Apple Valley, CAN8474PCopass Benjamin J · Fountain Run, KYN8475PBlackdog Air LLC · Wilmington, DEN8477PD F Osborne Construction Inc · Topeka, KSN847SPRothschild Joel S · Crestline, CAN8480PGlaser Violet E · Calhan, CON8481PBailey Roger R · Mineral, TXN8482PHogan John Robert · Palm Beach Gardens, FLN8483PHigh Wing Aviation LLC · Sardis, MSN8486PHaawq Air LLC · Brookshire, TX
Back to AD 66-30-07