AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N31900Woodward Joseph A Jr · Wshngtn Xing, PAN31905Weishuhn Aviation LLC · Farwell, MIN3190DDooyema Eric · Spokane, WAN3190FTimbol Julius J · Fair Oaks, CAN3190QHilton John C · Glastonbury, CTN3190RPace Richard · Leighton, ALN3190UTo Brand · Stanton, TXN3190YSpencer Thomas D · Brentwood, TNN31916Registered aircraftN3191APasternak Eliezer Trustee · Palo Alto, CAN3191MHerder John P · Phoenix, AZN3191PStone Clifford F Jr · Corning, CAN3191RLv Aviation LLC · Pompano Beach, FLN3191SSkydive Harbor Springs Inc · Charlevoix, MIN3191THappy Landings Aviation LLC · Maple, NCN3191UWings Of Hope · Chesterfield, MON31923Metro Aicraft Co · Bloomington, MNN31926Van Cura Don · Chicago, ILN3192CHansen Leland K · Phoenix, AZN3192LPolk Kenneth W · Greenville, TXN3192QSeel Jason L · Oak Creek, WIN3192RFuchs Robert D · Easton, PAN3192SFrandsen Perry D · Sandy, UTN3192THawley James W · Waddell, AZN3192UColonial Aviators LLC · Williamsburg, VAN3192WJ M Beech Inc · Wilmington, DEN3192YArea 52 Aviation LLC · Casper, WYN31933G & C Flying Inc · Litchfield, ILN31939Holt Thomas S · Layton, UTN3193DOrth Henry J · Wasilla, AKN3193FJcd4 Capital LLC · Birmingham, ALN3193RHolmes John H · Barto, PAN3193SHansen Arthur A · Lancaster, NYN3193XBlh Visions Mt LLC · Polson, MTN3193YDavis Loyal A · Santa Rosa, CAN3194CNortje Bryan John · Gold Hill, NCN3194DMatthews James B · Wills Point, TXN3194PGalindo Don R Jr · Walnut Grove, CAN3194WNiehaus Properties Inc · Portland, ORN3194XAutry Mark T · Sumter, SCN3194YSchexnayder Jennifer · New Roads, LAN3195Gorham Luke E · Wichita Falls, TXN31950Kasparie Ronald · Quincy, ILN3195DRegistration Pending · Fort Mohave, AZRegistration pendingN3195ECatlett John W · Briggsville, ARN3195KEasygoair LLC · Sudbury, MAN3195MAspire Management Inc · New Castle, DEN3195RPalmer Matthew B · Riverside, CAN3195UHinton Jake B · Mcdonough, GAN3195YFlyers Above The Payette LLC · Mccall, ID
Back to AD 2007-04-19 R1